Thursday 21 October 2010

Handling error in Excel embeding with MFC in Office 2010, Window 7, Visual Studio 2010

#import "C:\Program Files\Common Files\Microsoft Shared\OFFICE14\mso.dll" rename("RGB", "MSRGB")
#import "C:\Program Files (x86)\Common Files\microsoft shared\VBA\VBA6\VBE6EXT.OLB" raw_interfaces_only, rename("Reference", "ignorethis"), rename("VBE", "testVBE")
#import "C:\Program Files\Microsoft Office\OFFICE14\excel.exe" exclude("IFont", "IPicture") rename("RGB", "ignorethis"), rename("DialogBox", "ignorethis"), rename("VBE", "testVBE"), rename("ReplaceText", "EReplaceText"), rename("CopyFile","ECopyFile"), rename("FindText", "EFindText"), rename("NoPrompt", "ENoPrompt")
x86 is for 64 bit OS. If you are not using 64 bit OS, you don't need it

No comments: