PDA

View Full Version : Solved: Calling code from multiple documents



pairofskis
12-11-2008, 03:23 PM
I have written code that has procedures during the workbook_open() in Excel 03. I have 100s of documents that need to run this code, and the code will probably change at some point. Rather than having to go back and touch each and every document (workbook) to change the code, I was wondering how I could call the code from one file so that all documents can be updated at once when the code has to change. Any help would be appreciated.

Kenneth Hobs
12-11-2008, 07:30 PM
You could make an add-in.

Another method would be to make your macros open the workbook to run and run the macro with Application.Run.

pairofskis
12-12-2008, 07:33 AM
Addins are exactly what I was looking for! Million Thanks!!