Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've created an example.VBS file that contains:
----------------- Dim XLApp Set XLApp = CreateObject("Excel.Application") xlapp.visible = true xlapp.workbooks.open "myworkbook.xls" ----------------- In the myworkbook.xls is an auto run macro ------------- Sub Auto_Open() 'some code End Sub ------------- If I start the myworkbook.xls by itself it runs the Auto_Open() macro *just fine*. However, when my myworkbook.xls is called via the example.VBS script it DOES NOT auto run the macro. Any clues? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to get Started with macro? | Excel Discussion (Misc queries) | |||
Auto_Open Macro | Excel Discussion (Misc queries) | |||
auto_open macro not performing as expected | Excel Programming | |||
Help with SaveAs Macro on Auto_Open | Excel Programming | |||
Auto_Open vs. macro | Excel Programming |