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" <(E-Mail Removed)> wrote in message news:37878e4e-5fa1-4f73-b4ed-(E-Mail Removed)...
> 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
>