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

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

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

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

"Rodrigo" wrote in message
...
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

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

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


"Rodrigo" wrote in message
...
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