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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Command to run access, open to specific form and specific record 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Word to Excel: Export comments with text and line number 0
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Issue with Macro While running in Excel 2003 2
Workbooks.OpenText method help 3
Excel from the Command Line 1
Excel TWO Instances of Excel One watching Other 3

Back
Top