LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 115
Default VBS starts Excel. How to point to different macro when run?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel E-2007 starts, but Installer also starts 3 times??? Thanks for the Great Tip Setting up and Configuration of Excel 0 January 24th 10 03:21 AM
starts with decimal point only if number is like 0.###... markx Excel Worksheet Functions 3 September 14th 07 12:10 PM
Excel Starts up w/a Personal Macro page Parker Excel Discussion (Misc queries) 4 August 29th 05 09:31 PM
creating macro to ask for variable info when excel starts Flyriverside Excel Programming 1 April 7th 04 06:32 PM
Refer to a Name saved prior my macro Starts from VBA excel [email protected] Excel Programming 1 January 21st 04 11:47 AM


All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"