We've got an application front we've built which uses an Oracle back
end. It has poor graphics/analytics, and we'd like to use Excel for
that portion.

The only problem is that when we open Excel and connect to Oracle, we
still have to enter the ID# in Excel by hand.

We'd love be able to do something like run "analysis.xls /set/
ID=12345", and have it pass in ID=12345 as a variable to be used.
We're pretty good at developing Excel (use ADO pulls of Oracle data,
heavy into pivot tables and use buttons and forms coded through
VBA.)

But, we've never tried this.

I read the MS files about passing command line launch parameters via
"excel.exe ....", but didn't see anything about dumping named
variables in. (I might use them to force a "read only" open.)

We've thought about saving the ID to an Oracle database table, and
then having the Excel "on open" code check to see if there's an ID in
the last 30 seconds. However, this will be a multi-location, multi-
user application, and we'd rather not have to deal with figuring out
which row to open. (i.e. 2 people opening the Excel file at once.)

So, to restate the question:
Is there any way to pass a value to Excel (to VBA is okay) when
opening the file?

Thanks,

Jon