Hello,

I have about 100 excel files which I need to modify. I want to include
a Workbook_Open() script on each and every file. Instead of doing this
manually, is there a way to programmatically do it?

I know how to use VBA to open every file, but how do I access the VB
editor environment and "paste" my Workbook_Open() code in each file?


Any advice would be appreciated.

Thanks
H

Hi Henry

See this site
http://www.cpearson.com/excel/vbe.aspx

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Henry" wrote in message ...
Hello,

I have about 100 excel files which I need to modify. I want to include
a Workbook_Open() script on each and every file. Instead of doing this
manually, is there a way to programmatically do it?

I know how to use VBA to open every file, but how do I access the VB
editor environment and "paste" my Workbook_Open() code in each file?


Any advice would be appreciated.

Thanks
H