View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
CRayF CRayF is offline
external usenet poster
 
Posts: 115
Default The myworkbook.xls Auto_Open() macro won't run if started by a VBS

Thanks a million Juan. It's a wrap...

example.VBS contents:
-------------
Dim XLApp
Dim XLWkb
Set XLApp = CreateObject("Excel.Application")
xlapp.visible = true
xlapp.workbooks.open "myworkbook.xls"
xlapp.ActiveWorkbook.RunAutoMacros 1
-------------