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

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
 
N

NickHK

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
 
S

Steve Yandl

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
 

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

Unexplained read-only from a batch file 1
passing parameters from command line 5
Possible to pass a variable to Excel from command line/short cut? 2
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
How to get a file from a web page 1
How can I overwrite the last line data in text or csv file from VB 1
Framework 1.1 - opening Excel file 1
Excel VBA: Reading data from HTML-file 2

Top