Applying and saving an auto_open macro to all open workbooks

[kfryar]

Hi all,

I have a number of reports that i need to apply an Auto_Open macro to so that if someone opens any of the reports it will automatically refresh... I was hoping there was a way that i can do it in one go, opposed to going into 40 different reports and creating a new macro - can i do this?

K

[nathansav]

Yes, but you'll need to write the vba to open the files, access the VBE and insert your code. You can insert from a text file, so may be worth while looking at that.

This should help

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