Copying the Editing in one file to Another opened XLS file
 

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.co py
' then pick your poision:
Workbooks("Otherbook.xls").Worksheets(1).Cells.Pas teSpecial xlFormats
Workbooks("Otherbook.xls").Worksheets(1).Cells.Pas teSpecial xlValues
Workbooks("Otherbook.xls").Worksheets(1).Cells.Pas teSpecial xlFormulas
Workbooks("Otherbook.xls").Worksheets(1).Cells.Pas teSpecial xlPasteAll
--
Regards,
Tom Ogilvy


"Ahmad" wrote in message
oups.com...
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