{"id":119,"date":"2009-07-21T12:58:51","date_gmt":"2009-07-21T16:58:51","guid":{"rendered":"http:\/\/www.northatlantawebdesign.com\/?p=119"},"modified":"2009-07-27T10:04:02","modified_gmt":"2009-07-27T14:04:02","slug":"automating-excel-2007-in-c-by-importing-the-excel-2007-type-library","status":"publish","type":"post","link":"http:\/\/www.northatlantawebdesign.com\/index.php\/2009\/07\/21\/automating-excel-2007-in-c-by-importing-the-excel-2007-type-library\/","title":{"rendered":"Automating Excel 2007 in C++ by Importing the Excel 2007 Type Library"},"content":{"rendered":"

When I started trying to write automations for Excel 2007<\/a> using C++<\/a>, I ran into problems right up front. I was trying to use #import to get to the type library for Excel 2007, and was importing what I thought was the correct file. The following was written for a C++ application in Visual Studio 2008<\/a> (VS2008), automating Excel 2007.
\n<\/p>\n

    \n
  1. The Excel Type Library is not contained in XL5EN32.OLB as you might expect, it is contained in excel.exe<\/li>\n
  2. \nError #2: Even importing the correct file, errors were being raised.<\/p>\n
    \r\n\/\/The Following Import gives you the error Error\t1\terror C2504: '_IMsoDispObj' : base class undefined\r\n#import "C:\\Program Files\\Microsoft Office\\Office12\\EXCEL.EXE"\r\n<\/pre>\n
    To correctly import the Excel type library, two more references are needed: MSO.DLL and VBE6EXT.OLB<\/p>\n
    \r\n#import "C:\\Program Files\\Common Files\\Microsoft Shared\\OFFICE12\\mso.dll" no_implementation raw_interfaces_only\r\n#import "C:\\Program Files\\Common Files\\Microsoft Shared\\VBA\\VBA6\\VBE6EXT.OLB" no_implementation raw_interfaces_only\r\n#import "C:\\Program Files\\Microsoft Office\\OFFICE12\\excel.exe" no_implementation raw_interfaces_only\r\n<\/pre>\n<\/li>\n
  3. While this solved the problem of the _IMsoDispObj, it raised a few more issues.\n
    \r\nwarning C4003: not enough actual parameters for macro 'RGB'\r\nwarning C4003: not enough actual parameters for macro 'DialogBoxW'\r\n<\/pre>\n
    Finally I had the solution, renaming the objects in question that seemed to be redefined elsewhere.<\/p>\n
    \r\n#import "C:\\Program Files\\Common Files\\Microsoft Shared\\OFFICE12\\MSO.DLL" no_implementation rename("RGB", "ExclRGB") rename("DocumentProperties", "ExclDocumentProperties") rename("SearchPath", "ExclSearchPath")\r\n#import "C:\\Program Files\\Common Files\\Microsoft Shared\\VBA\\VBA6\\VBE6EXT.OLB" no_implementation\r\n#import "D:\\Program Files\\Microsoft Office\\OFFICE12\\EXCEL.EXE" rename("DialogBox", "ExclDialogBox") rename("RGB", "ExclRGB") rename("CopyFile", "ExclCopyFile") rename("ReplaceText", "ExclReplaceText")\r\n<\/pre>\n<\/li>\n<\/ol>\n
    So in conclusion, in order to import the Excel 2007 Type Library in C++ and use it in your automations, 3 files must be imported, MSO.DLL, VBE6EXT.OLB, and EXCEL.EXE.  On top of those three files, various objects must be renamed due to already being defined.  In my case it was the DialogBox and RGB, though it may differ on each project depending on what is defined.  Here is the final code needed to import the type library.<\/p>\n
    \r\n#import "C:\\Program Files\\Common Files\\Microsoft Shared\\OFFICE12\\MSO.DLL" no_implementation rename("RGB", "ExclRGB") rename("DocumentProperties", "ExclDocumentProperties") rename("SearchPath", "ExclSearchPath")\r\n#import "C:\\Program Files\\Common Files\\Microsoft Shared\\VBA\\VBA6\\VBE6EXT.OLB" no_implementation\r\n#import "D:\\Program Files\\Microsoft Office\\OFFICE12\\EXCEL.EXE" rename("DialogBox", "ExclDialogBox") rename("RGB", "ExclRGB") rename("CopyFile", "ExclCopyFile") rename("ReplaceText", "ExclReplaceText")\r\n<\/pre>\n
    Useful Links:<\/p>\n