How to use Excel COM interface in VC ???


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 :)

Who is Participating?
hasmetConnect With a Mentor Commented:
First you #import the typelibs
#import <C:\Program Files\Microsoft Office\Office\mso9.dll>
#import <C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB>
#import <C:\Program Files\Microsoft Office\Office\excel9.olb> rename("DialogBox", "DialogBoxXL") rename("RGB", "RGB_XL") named_guids

put the correct path!!!

declare your Application pointer

      Excel::_ApplicationPtr m_pAppExcel;


      HRESULT hr;
      hr = m_pAppExcel.CreateInstance(__uuidof(Excel::Application));
            _bstr_t bstrTitle("my excel");
            Excel::_WorkbookPtr pDum = m_pAppExcel->GetWorkbooks()->Add();

If you have VC++ 6, intellisense
will work just as in VBA. AND if you have VBA code, then it is almost identical to convert like this.
If you've already got working VB code, find the corresponding objects in the header files you have and find their corresponding CLSIDs.  The names of the classes used in VB will be the same as in the header files.

Am I missing something?
aquila98Author Commented:
Very nice! Thanks ;-)
That's what was missing I guess... The #inport :)

Except, I got these errors for the excel9 file:
excel9.tlh(10494) : warning C4003: not enough actual parameters for macro 'DialogBoxA'
excel9.tlh(10494) : error C2059: syntax error : ',

It's complaining about this DialogBoxA is there
any more rename I should do?

I am close to a solution, thanks for your help
aquila98Author Commented:
Silly me!

I remembered the rename MUST be on the same line
as the import for it to work ;-)

Thanks for your help
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.