run excel from the command line

  • Thread starter Thread starter John Gilchrist
  • Start date Start date
J

John Gilchrist

Can you open a specified excel file from the command line as follows:

1. Open a specific excel file
2. Run a macro automatically @ startup
3. pass a file specification (filename.ext) to an embedded macro as a
command line argument?

Where can I find more information on running MS Excel from the command line?

Thanks,
John
 
Maybe...
#1. Create a short cut to that specific excel file and just start that.
#2. Name your macro Auto_Open and it'll start when excel loads your workbook.
#3. Embed the name into that macro and always use the same name to make the
code easier.
 
Back
Top