How can i read Command Line parametres from Excel 2003 file???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi guys:

I need a tips related to run the following shorcut:

c:\MyBook.xls parameter1 parameter2..

in order to use those parameters in a Query that already exists in the excel
file "Mybook.xls"

Thanks & Regards
Rodrigo
 
Rodrigo,
You can't pass parameters, as a command line, to an xls file as it is not an
executable.
You open the WB and set the relevant cell values with automation.

NickHK
 
You could use an indirect method where you launch a vbs file that takes
arguments and also launches your xls file. Script within the vbs file can
be written to either run a macro within your xls file or populate certain
cells with the values given by the arguments. The "Wscript.Shell" opject
has an arguments collection.

Steve Yandl
 
You must log in or register to reply here.

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

Excel Command line 2
Excel VBA: Reading data from HTML-file 2
Porting from Excel 2003 to Excel 2010 12
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Unexplained read-only from a batch file 1
Problems executing commands on one file from another 11
passing parameters from command line 5
How do I suppress user dialog in File Save As? 1

Back
Top