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

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

Look:
http://www.google.fr/groups?hl=fr&lr....phx.gbl#link4

MP

"M Carothers" a écrit dans le message
de ...
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

Michel,
I stand corrected. Good to know.

NickHK


"Michel Pierron" wrote in message
...
Look:

http://www.google.fr/groups?hl=fr&lr...5a7f0&s eekm=
Od3YRGRDFHA.1296%40TK2MSFTNGP10.phx.gbl#link4

MP

"M Carothers" a écrit dans le
message
de ...
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