View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
timebird timebird is offline
external usenet poster
 
Posts: 16
Default execute macro from command line

it's unusual to execute a vba macro from the command line.
how about coding windows shell program that automates the excel?
shell programming uses vbscript(*.vbs) or javascript(*.js)
if you're familiar with vba, you would not have difficulty with that.

plz refer http://msdn2.microsoft.com/en-us/library/aa286544.aspx


--
msn
---------------------------------------------
the best time to plant a tree was twenty years ago.
the second best time, is today - Chinese proverb



"swansong" wrote:

Hello,

I would like to run a macro in a workbook from the command line. The macro
modifies the contents of the workbook. This is so I can automate a task
rather than open the workbook, run macro, and save.

Thanks!