M,
AFAIK you cannot read Excel's command line arguments.
That leaves you 3 options:
1. Use automation, open workbook, straight forward process
2. Use ADO, no need to open, but could be tricky depending on your layout
3. Use the older Macro format. Never used it.

NickHK

"M Carothers" wrote in message
...
I am trying to pass a value into an excel workbook to populate a cell
within
a worksheet. The value is dynamic and will create a worksheet by inserting
the value passed to a data query.
--
Thanks in advance for the help
Var The Stick