Thanks Jim.

Using files would do it. Using registry sounds a bit neater but I do
not know how to use write values from c++ program to the registry and
how the excel spreadsheet would then pick up these values. Similarly do
not know how to write values from the spreadsheet to the registry and
how the c++ program would "read" them.

Any further thoughts please?

Thanks

Jim Rech wrote:
The Shell function does not provide for passing parameters to the called
program (see Help). I suppose you could write out your variables to a file
or to the registry. Similarly on return.

--
Jim
"ellis kurland" wrote in message
...
|I have an excel spreadsheet and call a C++ program from a VBA macro using
| the command below. (I am not using visual C++ but a command line driven
| version, Borland C++ compiler)
|
| retval = Shell ("c:\options\options1.exe", vbNormalFocus)
|
|
| What I want to be able to do is to pass some of the values in my excel
| spreadhseet to the C++ program when calling it. There are 5
| variables(spreadsheet cells) whose numerical values I want to pass across
to
| the program.
|
| Once the C++ program has run I want to put a value that it caluculates in
to
| a cell in my excel spreadsheet.
|
| Any help much appreciated please.
|
| Many thanks
|
|