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
 

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

Y i m getting fatal error LNK1179: invalid or corrupt file: duplicate COMDAT '_IID_Diagram' 0
Serialize Obj from App A and Deserialize it from App B 2
Converted xlsx file to xls. New xls file isn't right, try to correct, fails compat checker 0
Serializing Multiple Objects of a Class 5
Excel Excel cannot open .xls file 0
How to stop: Microsoft XLS is locked for editing in 2003 Excel 1
Formulas & Dates not working in .xls file 1
Excel How to activate already opend PDF file through VBA code 1

Top