Command line arguments?
Posted by Larry Jones on April 25, 2001 1:02 PM
This is driving me crazy! Surely there is a way to pass an argument to an Excel spreadsheet so the code in the Open event can process the argument!???
I need to open an Excel workbook from an application or from the web interface, passing an value to the workbook that will automatically be found and shown when the workbook opens. I could have the user re-enter the value, but since they will have already done that once, that seems like a waste and I know the user will not like that approach.
The Command() function does not work, and so far I have not had any luck with the GetCommandLine API function either.
I am using NT 4.0 and Excel 97.