What is the best way to exchange data between an executable and
VB?
For example, I have an executable (Test.exe) that takes two input variables
and then returns their sum. I use the Shell function:
RetVal = Shell(€śC:\Test.exe 3 4€ť)
Test.exe returns 7 (3+4) but this value is not passed to
VB (The value
returned by Shell is a Task ID number). How do I get the returned value of
Test.exe in
VB? Is there a better way to exchange data than using the Shell
function?
The big picture objective here is to be able write computationally intensive
routines in C and call them from within Excel
VB.
Tx,
Randall