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.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
--
Regards,
Tom Ogilvy


"Ahmad" <[email protected]> wrote in message
news:[email protected]...
> 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
>