View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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?
|
|