Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to access Visual Basic Editor via VBA?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to access Visual Basic Editor via VBA?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Visual Basic Editor | Excel Discussion (Misc queries) | |||
Visual Basic Editor | Excel Discussion (Misc queries) | |||
Visual basic editor | Excel Discussion (Misc queries) | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
VBE(Visual Basic Editor) Keep focus in VBE | Excel Programming |