Copying the Editing in one file to Another opened XLS file

  • Thread starter Thread starter Ahmad
  • Start date Start date
A

Ahmad

hi!

I have been given a task to develop some plugin for excel that will
copy any type of editing in the current excel file to the other opened
excel file.

Is it possible. If so then please guide me how to achieve it.

Thanks in advance.

Ahmad Jalil Qarshi
 
Depends on what you mean by editing -

Workbooks("sourcebooks.xls).Worksheets(1).cells.copy
' then pick your poision:
Workbooks("Otherbook.xls").Worksheets(1).Cells.PasteSpecial xlFormats
Workbooks("Otherbook.xls").Worksheets(1).Cells.PasteSpecial xlValues
Workbooks("Otherbook.xls").Worksheets(1).Cells.PasteSpecial xlFormulas
Workbooks("Otherbook.xls").Worksheets(1).Cells.PasteSpecial xlPasteAll
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing Thousands of PDF Files 1
Excel file extension is camouflaged as xls 1
Converted xlsx file to xls. New xls file isn't right, try to correct, fails compat checker 0
Open .xlsx files in Excel 2002 2
Excel Excel cannot open .xls file 0
Excel How to Fix Damaged Excel File That Won't Open? 3
Excel Unlink open excel files 2
Y i m getting fatal error LNK1179: invalid or corrupt file: duplicate COMDAT '_IID_Diagram' 0

Back
Top