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

"Rodrigo" <(E-Mail Removed)> wrote in message
news:24D893E7-1A08-4748-9A29-(E-Mail Removed)...
> 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
>
>
>

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" <(E-Mail Removed)> wrote in message
news:24D893E7-1A08-4748-9A29-(E-Mail Removed)...
> 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
>
>
>