Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting the same Excel macro to 60 workbooks
Hi all!
I was wondering if anyone can help me with an Excel VBA problem. I am trying to use the same macro (via a Module) for 60 different pre-existing Excel workbooks. What I did was make a change to the code in an existing template, and need to propogate it to all Excel books that were created previously from this Template. Please help with any suggestions! Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting the same Excel macro to 60 workbooks
Look at Chip Pearson's page on working with code using code
http://www.cpearson.com/excel.htm If the projects are locked, then this will be more then extremely difficult. -- Regards, Tom Ogilvy wrote in message oups.com... Hi all! I was wondering if anyone can help me with an Excel VBA problem. I am trying to use the same macro (via a Module) for 60 different pre-existing Excel workbooks. What I did was make a change to the code in an existing template, and need to propogate it to all Excel books that were created previously from this Template. Please help with any suggestions! Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting the same Excel macro to 60 workbooks
wrote in message oups.com... Hi all! I was wondering if anyone can help me with an Excel VBA problem. I am trying to use the same macro (via a Module) for 60 different pre-existing Excel workbooks. What I did was make a change to the code in an existing template, and need to propogate it to all Excel books that were created previously from this Template. Please help with any suggestions! Thanks! Maybe you should write an xla add-in instead. /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
exporting a macro | Excel Discussion (Misc queries) | |||
Exporting a Macro | Excel Discussion (Misc queries) | |||
Using Macro in Several Excel Workbooks | Excel Discussion (Misc queries) | |||
Need Excel macro for exporting data to Access | Excel Programming | |||
Excel Macro exporting to MS-Project 2002 | Excel Programming |