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 |
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 |