iamadamc
asked on
Calling Excel Macro (Sub) from Visual Basic 6.0
Please advise how to call a macro (sub) in Excel (Office XP) from a Visual Basic 6.0 Script. Thx! - Adam
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
'Creates an object
ApExcel.Visible = True ' So you can see Excel
ApExcel.Workbooks.Open FileName:=gstrMacroPath
ApExcel.Application.Run "auto_open"
ApExcel.Application.Quit