Ok let me first answer your question and secondly suggest a better alternative
You missed a line ===> rename_namespace("Excel")
#import "C:\\Program Files (x86)\\Common Files\\microsoft shared\\OFFICE14\\MSO.DLL" \
rename( "RGB", "MSORGB" ) \
exclude( "DocumentProperties")
using namespace Office;
#import "C:\\Program Files (x86)\\Common Files\\Microsoft Shared\\VBA\\VBA6\\VBE6EXT.OLB"
using namespace VBIDE;
#import "C:\\Program Files (x86)\\Microsoft Office\\OFFICE14\\EXCEL.EXE" \
rename_namespace("Excel") \
rename("DialogBox", "DialogBoxXL") \
rename("RGB", "RBGXL") \
rename("DocumentProperties", "DocumentPropertiesXL") \
rename("ReplaceText", "ReplaceTextXL") \
rename("CopyFile", "CopyFileXL") \
exclude( "IFont", "IPicture") \
no_dual_interfaces
using namespace std;
The simpler alternative is to connect an ODBC data source from control panel to the excel file and access it from the ODBC interface.
If you want to look at that download the free personal edition of SqlDbx, connect an excel file as an ODBC data source from control panel and connect to it on SqlDbx. Play and edit the SQL file to your hearts content.
There is a multitude of ODBC code available which will let you do the same things.