View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Yandl Steve Yandl is offline
external usenet poster
 
Posts: 284
Default 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