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!

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


<[email protected]> wrote in message
news:[email protected]...
> 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!
>

<[email protected]> wrote in message
news:[email protected]...
> 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