Can you not use the /cmd on the command line and then parse whatever
follows /cmd with the COMMAND function in the open_event?

martin

On Tue, 16 Dec 2003 17:04:32 -0800, Telly Massaras
wrote:


Nick,

Thanks for your reply. The values that I want to pass in will be
different every time. One value will be a string and the other is an
number. Once the data is read-in to Excell, it will passed into a macro
which will use the values to form a file name from which to read data.
How would the workbook_open event work? It's triggered upon start-up
but how do the values get into Excell?

Thanks,

Telly...



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!