How to use Excel COM interface in VC ???
Posted on 2000-05-09
I have been able to get (using OLEView) the stub files for the COM
interface to Excel (XL5EN32.c and XL5EN32.h/idl)... So far so good :)
But which of the hundreds of CLSID do I use to instanciate an object?
And which objects to instanciate???
Here's what I want to do:
Open an XL sheet in a C++ application (MFC);
Read some cells;
Write to some cells;
save the sheet.
All this is simple in VB once you get a starting object...
But how to do it in VC??? Any hints? Any doc anywhere online?
I guess this code is close:
hr = CoInitialize(0);
Application *w; // is this the right starting object???
hr = CoCreateInstance( CLSID__ExcelApplication, NULL,
CLSCTX_INPROC_SERVER, DIID_Application, (void**) &w);
is it the right CLSID and IDD???
any hints on how to use this interface in VC will be welcomed :)