A question on automating Excel from a C++ program

[Smasher/Devourer]

I've got an MFC program that I wrote using Visual C++ 6. I'd like that program to be able to modify an existing MS Excel spreadsheet by opening that spreadsheet and passing arguments to a VB macro stored within it. If it matters, the macro has the form:

Sub AddItem(ItemDesc As String, ItemCount As Integer)
    ' ... lots of stuff happens ... 
End Sub

I haven't done anything like this before so am kind of at a loss as to where to begin. I don't need a lot of details; basically I just would like someone to tell me what I should start reading to figure out how to send commands to Excel from a C++ program. Thanks!

[golanshahar]

I've got an MFC program that I wrote using Visual C++ 6. I'd like that program to be able to modify an existing MS Excel spreadsheet by opening that spreadsheet and passing arguments to a VB macro stored within it. If it matters, the macro has the form:

Sub AddItem(ItemDesc As String, ItemCount As Integer)
    ' ... lots of stuff happens ... 
End Sub

I haven't done anything like this before so am kind of at a loss as to where to begin. I don't need a lot of details; basically I just would like someone to tell me what I should start reading to figure out how to send commands to Excel from a C++ program. Thanks!

Hi Smasher, good to have ya back

maybe this thread can help you out: How to load an Excel file.

BTW where is exactly the problem? In activating the macro? Or just load Excel file using automation and control it?

Cheers

[Tom Frohman]

For an example of running a macro from VC see :
Excel Macro