Exporting the same Excel macro to 60 workbooks

[haas786]

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!

 

[Tom Ogilvy]

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.

 

[Fredrik Wahlgren]

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