Copying the Editing in one file to Another opened XLS file

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
 
T

Tom Ogilvy

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
 
Top