Passing arguments when opening Excel

I've been looking all over the net for tips on how to pass command-line arguments to a worksheet.

Many pages refer to a function in "kernel32" with a "Auto_open" sub, but all these apply to Excel 97!!!

The "Command"-method doesn't seem to catch my arguments either...

How can i start a workbook like this:

\\server\share\folder\myworkbook.xls /param1 /param2 /param3

...and catch the params in my VBA macro?

/David

Hi,

your comments indicate that you cannot use Excel 97 code but you don't mention which version of Excel you are using.

regards

I use 2003.

/David

I am not sure that you can do it directly in Excel. I would be glad to be proven wrong.

To get the same effect write an Excel launcher in VB ; collect the command line and pass it to your launched excel application.

I suspect you maybe able to do it in VBScript as well


Hope this helps