Transfer Data between C++ and Excel

[andyroo]

I need to be able to open an instance of Excel from a C++ program, transfer data to and from the a worksheet and leave Excel open when the program finishes ... could someone point me in the right direction as I don't know where to start

TIA

Andy

 

[crux]

The simple way is:
Create a file in '.csv' or '.slk' format.
Then open the file with 'ShellExecute' command.
NOTE: These formats don't support graphs, only data.

 

[andyroo]

Thanks for the info, that piece of code opens another app but how do I get info to and from it ?

 

[PhilMunro]

Try the 'COMEXCEL' Automation sample in MSDN.

Good luck Phil