Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Script vs Open_Event
Hello. I have a macro In WorkbookA that Opens WoekbookB. In WorkbookB is
an Open event module that does some stuff. Is there any difference in having WorkbookA Open a VBScript, and have the VB script open WorkbookB and run Macro1 in WorkbookB (thereby eliminating the need for an Open_Event in WorkbookB). Anty difference in performance? Will the user see anything different? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Script vs Open_Event
If you want the code in WB2 to always run, whether opened from WB1 or on its
own, then put it in WB2. Otherwise put it in WB1 since it's specified to WB1. -- Jim "Steph" wrote in message ... | Hello. I have a macro In WorkbookA that Opens WoekbookB. In WorkbookB is | an Open event module that does some stuff. | | Is there any difference in having WorkbookA Open a VBScript, and have the VB | script open WorkbookB and run Macro1 in WorkbookB (thereby eliminating the | need for an Open_Event in WorkbookB). | | Anty difference in performance? Will the user see anything different? | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with vba script | New Users to Excel | |||
Help with VB script please? | Excel Programming | |||
Excel 2000/XP script to Excel97 script | Excel Programming | |||
Script? | Excel Programming | |||
what is a vb script | Excel Programming |