Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Sheet Object Module
Hello,
I have both a sheet object module and a standard module that I need to copy to all workbooks in a folder. What would be the code to help me accomplish that? Any help/suggestion wold be appreciated. Thank you. Filo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Sheet Object Module
Depending if you mean manually:
The standard module you can export, then import into each of the WBs The sheet needs to be copied to each of the WBs, as it cannot "live" outside of a WB, if you need the WS data. If you only need the code, you can export it and it will become a class module, which you can then import. The destination WBs will need to be open to import. If you mean by code: http://www.cpearson.com/excel/vbe.htm NickHK "Filo" wrote in message ... Hello, I have both a sheet object module and a standard module that I need to copy to all workbooks in a folder. What would be the code to help me accomplish that? Any help/suggestion wold be appreciated. Thank you. Filo |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Sheet Object Module
Thank you. I needed the 'with code' option and found everything I needed
at Chip Peasrson's site http://www.cpearson.com/excel/vbe.htm Awesome! "NickHK" wrote: Depending if you mean manually: The standard module you can export, then import into each of the WBs The sheet needs to be copied to each of the WBs, as it cannot "live" outside of a WB, if you need the WS data. If you only need the code, you can export it and it will become a class module, which you can then import. The destination WBs will need to be open to import. If you mean by code: http://www.cpearson.com/excel/vbe.htm NickHK "Filo" wrote in message ... Hello, I have both a sheet object module and a standard module that I need to copy to all workbooks in a folder. What would be the code to help me accomplish that? Any help/suggestion wold be appreciated. Thank you. Filo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy an image object to new location in shame sheet, Excel. | Excel Programming | |||
Protect excel sheet and still copy text or object w/o unprotectin. | Excel Discussion (Misc queries) | |||
Calls from sheet module to ThisWorkbook module | Excel Programming | |||
Copy Rectangle Object From One Sheet To Another | Excel Discussion (Misc queries) | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |