Storing VBA Code in external file

[jasonp128]

I don't know if there is a way to do this or not. I have a situation where I
have a publisher document I've created that is used as a template file. The
document has all of my custom built VBA code in macros, but I end up making
close to 500 copies of this document throughout the month for various clients
(think newsletter where each client's document is personalized). Inevitably
I find something I would like to tweak in my VBA code after I have several
hundred copies of the document already created. If possible I'd love to
consolidate all my code into a single document that I reference so that if I
make any changes I can do so to one document so I could instantly fix my code
for all documents rather than having to either wait until next month for the
change, or changing every document.

Any help or ideas would be greatly appreciated. Thank you in advance...

Jason

 

[Ed Bennett]

If possible I'd love to consolidate all my code into a single
document that I reference so that if I make any changes I can do so
to one document so I could instantly fix my code for all documents
rather than having to either wait until next month for the change, or
changing every document.

As far as I know this isn't possible, but you might consider
reimplementing the code as a COM Add-in instead.

See:
http://ed.mvps.org/Static.aspx?=Publisher/tutaddin

 

[jasonp128]

Thanks Ed, You pretty much confirmed my suspicions