Copying Macro to Several Workbooks Fast

[nickg420]

I have a macro which executes at the open of a workbook. The problem i
I need this to be used on about 100 different workbooks on
centralized server. Is there any way to do this as quickly as possibl
besides manually opening each workbook, then copying and pasting thi
code into the VB Code Editor? Any help would be greatly appreciated.

Thanks,
N

 

[Dave Peterson]

Chip Pearson has some explanation on how to import text files into VBA Projects:

http://www.cpearson.com/excel/vbe.htm

But he also has some notes on how to set up an Application Event (maybe you can
isolate the workbooks (name of the folder) some way). Then just have this
application event fire when one of those workbooks open.

http://www.cpearson.com/excel/AppEvent.htm