When trying to Automate Excel, Word, etc using VC++ (MFC based application) in Visual Studio 2010 we generally perform the following steps –
1-Go to Visual Studio
2-Click New Project
3-Expand Visual C++ tree node
5-Select MFC Application
6-Enter project name, click OK
7-Choose a dialog based project
9-The bare bone project is created
In order to add an MFC Class from Typelib, we do the following –
10-Right click project -> Add -> Class
11-Select “MFC Class from TypeLib” , say Add
12-In the list of available type libraries, choose Microsoft Excel 14.0 Object Library
13-Then choose the list of classes you are planning to use inthe project, eg, _Application, _Workbook etc
Once you are done, you will see the relevant header filesbeing added – eg- CApplication.h, CWorkbook.h etc
Now in order to automate, you will be required to includethe appropriate header file in your projects cpp file, eg, TestDlg.cpp
Eg, #include "CApplication.h"
Now begins the trouble -
As soon as you include the respective header files, you willbe presented with a huge number of errors (300+ errors) being thrown duringcompilation.
Some errors may appear like –
error C2011: 'Picture' : 'struct' type redefinition
syntax error : identifier 'MsoRGBType'
syntax error : '<L_TYPE_raw>'
etc, etc, etc
In order to resolve these mean errors, you need to do a small step –
Go to the top of each header file and locate the followingline
#import "C:\\Program Files(x86)\\Microsoft Office\\Office14\\EXCEL.EXE" no_namespace
Comment this line for each Excel(Office) related header files individually in order to get rid of the compilation errors.