cfman wrote:
Hi Chip,

Thanks a lot for your help!

I was also wondering if the following scheme is possible:

Users set parameters in Excel, and then hit a button to launch my C/C++
program, which does all the computations, and then waits for the C/C++
program to send back the results; once the results are available, the Excel
program will plot the results.

My question is: how does the Excel program knows if the results have been
sent back by the C/C++ program and are available?

More specifically, I guess when the users hit a button, it's going to be a
VBA macro, then how does VBA macro handles the above interface back and
forth with C/C++ back-end?

Thanks a lot

There's an entire book about developing financial XLLs in C++. See this
article and the book references at the end.
http://msdn2.microsoft.com/en-us/library/aa730920.aspx

--
Scott McPhillips [VC++ MVP]