View Single Post
  #7  
Old 08-04-2009, 12:16 AM
MynameisKamath MynameisKamath is offline
Registered User
 
Join Date: 04 Aug 2009
Location: India
MS Office Version:Excel 2003
Posts: 1
MynameisKamath is becoming part of the community
Re: Run macro from command line

Hi,
Say if u want to open a run a Macro called "MacroName" from the CMD prompt then u can do the following. All the u need to do is to ADD a new function called "Auto_Open"

Private Sub Auto_Open()
MacroName
End Sub


Then enter on the command line:
c:\MyexcelSS.xls

This should execute the macro.

Regards
Kamath
Reply With Quote