Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the folloining code in a file called RaceBetting.vbs. When run, it
startes the the RaceBetting.xls and runs the "AutoOpen" macro. I would like to point it to run a different macro when run. Below the: XLApp.ActiveWorkbook.RunAutoMacros 1 points to a number. How do I relate this to the macros? The Macro I want to run is "ImportRaceProgramData()" instead of the Auto_Open() --------------------- Dim XLApp Dim XLWkb Set XLApp = CreateObject("Excel.Application") XLApp.Visible = true XLApp.Workbooks.Open "RaceBetting.xls" XLApp.ActiveWorkbook.RunAutoMacros 1 -------------------- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel E-2007 starts, but Installer also starts 3 times??? | Setting up and Configuration of Excel | |||
starts with decimal point only if number is like 0.###... | Excel Worksheet Functions | |||
Excel Starts up w/a Personal Macro page | Excel Discussion (Misc queries) | |||
creating macro to ask for variable info when excel starts | Excel Programming | |||
Refer to a Name saved prior my macro Starts from VBA excel | Excel Programming |