How do I pass a parameter from the command line?

[Azerty99]

Guys, How do I pass a parameter into Excel from the command line:
Something like

start excel test.xls(Workbook_Open(99))

or

start excel test.xls(99)

where 99 is the parameter which is passed to the open sub?

Private Sub Workbook_Open(comm as String)
    MsgBox comm
End Sub

Obviously I want to do more with the parameter. For now just to get it working in a msgbox is fine.

I found this on a search

MrExcelLink

But the answer suggested an input box. I need an automated facility as the run will be 12 iterations through the file, from a fixed parameter file.

Thanks

Excel 2003
Windows XP Professional

 

[Ruddles]

The final post in that thread contains the actual solution - not using InputBox.

The solution depends on how you're intending to start Excel. What command are you using and from where are you issuing it?

 

[Azerty99]

The final post in that thread contains the actual solution - not using InputBox.

The solution depends on how you're intending to start Excel. What command are you using and from where are you issuing it?

Thanks Ruddles - will give this a go

 

[Azerty99]

(Sorry tried to edit my last post - ther's a 10 minute time limit.....)

Except it doesn't work

Tried:

start excel test.xls 99

I get msgbox = 133016

it says it can't find 99.xls

 

[Ruddles]

I just added this code to a workbook and opened it from Start > Run with this:-

excel f:\command_line_parameter.xlsm /123456

and it worked fine.

Where are you entering start excel test.xls 99?

 

[Azerty99]

start excel test.xls /99

Doesn't work

Am working in a system with no direct access to the command line, and restricted access elsewhere

start excel test.xls

Opens Test OK

but of course this is not quite true as I cannot actually type this in anywhere. I have to run it from another application with indirect access to the command line.

But leave it, it was getting way too complex for what I was trying to do. Just thought it maybe a one line command in Windows which it obviously isn't