| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how i make a pgm in excel for copying all the rows to a new file . | Excel Discussion (Misc queries) | |||
| Problem Editing Macro in Shared Excel File | Excel Discussion (Misc queries) | |||
| Problem Editing Macro in Shared Excel File | Excel Discussion (Misc queries) | |||
| Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
| File is locked for Editing by user problem | Excel Discussion (Misc queries) | |||
Hybrid Mode
