RE: Visual C++ 2005 Excel Automation

From: GrkEngineer <GrkEngineer@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 17 Apr 2006 11:06:30 -0700

Reggy_reg,

Were you able to solve your problem? I'm having the same issue with
Powerpoint and I've tried the namespace, but still have the same issues.
Perhaps I'm not doing it correctly. Just wondering you were able to use the
namespace to help. If so could you let me know how you did it?

"reggy_reg@xxxxxxxxxxx" wrote:

Does anyone know the proper import statements to automate Excel 10
using .net
or Visual Studio 20005

I am running into the bug where the COM wrappers cannot resolve between
Excel
objects and Windows API objects

http://support.microsoft.com/kb/311407/EN-US/

I am using this import

#import "C:\\Program Files\\Microsoft Office\\Office10\\EXCEL.EXE"
no_namespace \
rename("Font", "ExcelFont") rename("DialogBox", "ExcelDialogBox") \
rename("DocumentProperties", "ExcelDocumentProperties") \
rename("ExitWindows", "ExcelExitWindows") rename("RGB", "ExcelRGB") \
rename("Rectangle", "ExcelRectangle") rename("Arc", "ExcelArc") \
rename("CopyFile", "ExcelCopyFile") \
rename("Picture", "ExcelPicture") rename ("ReplaceText",
"ExcelReplaceText")\

These are the areas i am receiving:

Compiling...
AutoProject3Dlg.cpp
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(1590) : error
C2504: '_IMsoDispObj' : base class undefined
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(1632) : error
C2504: '_IMsoDispObj' : base class undefined
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(1734) : error
C2504: '_IMsoDispObj' : base class undefined
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(1753) : error
C2146: syntax error : missing ';' before identifier 'GetExcelRGB'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(1753) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(1753) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(1753) : warning
C4183: 'GetExcelRGB': missing return type; assumed to be a member
function returning 'int'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(1755) : error
C2061: syntax error : identifier 'MsoRGBType'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(1771) : error
C2061: syntax error : identifier 'MsoRGBType'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(1773) : error
C2061: syntax error : identifier 'MsoRGBType'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(1788) : error
C2504: '_IMsoDispObj' : base class undefined
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(1918) : error
C2504: '_IMsoDispObj' : base class undefined
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(1957) : error
C2504: '_IMsoDispObj' : base class undefined
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(2040) : error
C2504: '_IMsoDispObj' : base class undefined
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(2090) : error
C2146: syntax error : missing ';' before identifier
'GetTransparencyColor'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(2090) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(2090) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(2090) : warning
C4183: 'GetTransparencyColor': missing return type; assumed to be a
member function returning 'int'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(2092) : error
C2061: syntax error : identifier 'MsoRGBType'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(2136) : error
C2061: syntax error : identifier 'MsoRGBType'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(2138) : error
C2061: syntax error : identifier 'MsoRGBType'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(2147) : error
C2504: '_IMsoDispObj' : base class undefined
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(2236) : error
C2504: '_IMsoDispObj' : base class undefined
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(2354) : error
C2504: '_IMsoDispObj' : base class undefined
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(2480) : error
C2504: '_IMsoDispObj' : base class undefined
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(17852) : error
C2146: syntax error : missing ';' before identifier 'Scripts'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(17852) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(17852) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(17898) : error
C2146: syntax error : missing ';' before identifier 'MailEnvelope'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(17898) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(17898) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(18103) : error
C2146: syntax error : missing ';' before identifier 'GetScripts'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(18103) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(18103) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(18103) :
warning C4183: 'GetScripts': missing return type; assumed to be a
member function returning 'int'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(18121) : error
C2146: syntax error : missing ';' before identifier 'GetMailEnvelope'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(18121) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(18121) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(18121) :
warning C4183: 'GetMailEnvelope': missing return type; assumed to be a
member function returning 'int'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23025) : error
C2146: syntax error : missing ';' before identifier 'Script'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23025) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23025) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23051) : error
C2146: syntax error : missing ';' before identifier 'CanvasItems'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23051) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23051) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23230) : error
C2146: syntax error : missing ';' before identifier 'GetScript'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23230) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23230) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23230) :
warning C4183: 'GetScript': missing return type; assumed to be a member
function returning 'int'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23237) : error
C2146: syntax error : missing ';' before identifier 'GetCanvasItems'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23237) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23237) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23237) :
warning C4183: 'GetCanvasItems': missing return type; assumed to be a
member function returning 'int'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23415) : error
C2146: syntax error : missing ';' before identifier 'CanvasItems'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23415) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23415) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23570) : error
C2146: syntax error : missing ';' before identifier 'GetCanvasItems'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23570) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23570) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(23570) :
warning C4183: 'GetCanvasItems': missing return type; assumed to be a
member function returning 'int'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(29496) : error
C2146: syntax error : missing ';' before identifier 'MailEnvelope'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(29496) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(29496) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(29516) : error
C2146: syntax error : missing ';' before identifier 'Scripts'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(29516) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(29516) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(29896) : error
C2146: syntax error : missing ';' before identifier 'GetScripts'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(29896) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(29896) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(29896) :
warning C4183: 'GetScripts': missing return type; assumed to be a
member function returning 'int'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(29916) : error
C2146: syntax error : missing ';' before identifier 'GetMailEnvelope'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(29916) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(29916) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(29916) :
warning C4183: 'GetMailEnvelope': missing return type; assumed to be a
member function returning 'int'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(45850) : error
C2146: syntax error : missing ';' before identifier 'Scripts'
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(45850) : error
C4430: missing type specifier - int assumed. Note: C++ does not support
default-int
c:\documents and settings\xsfredie\my documents\visual studio
2005\projects\autoproject3\autoproject3\debug\excel.tlh(45850) : error

Prev by Date: RE: Automating Outlook "New Mail Message" from .NET Winforms - Upgrade
Next by Date: Re: Creating many letters(mail merge) from a single template in C#
Previous by thread: RE: Automating Outlook "New Mail Message" from .NET Winforms - Upgrade
Next by thread: Re: Office SDK samples fail after Office SP2 installed
Index(es):
- Date
- Thread

Relevant Pages

Visual C++ 2005 Excel Automation
... or Visual Studio 20005 ... C4183: 'GetExcelRGB': missing return type; ... member function returning 'int' ...
(microsoft.public.office.developer.automation)
Visual C++ 2005 Excel 10
... or Visual Studio 20005 ... C4183: 'GetExcelRGB': missing return type; ... member function returning 'int' ...
(microsoft.public.excel.programming)
Visual Studio C++ 2005 Excel 10 Automation
... or Visual Studio 20005 ... C4183: 'GetExcelRGB': missing return type; ... member function returning 'int' ...
(microsoft.public.vc.language)
Re: MEX files.
... C4183: 'getCovariance': missing return type; ... a member function returning 'int' ...
(comp.soft-sys.matlab)
Re: Nice farewell
... I tend to think what's missing in Studio 60 is something important. ... Studio 60 and I put Sports Night in my Netflix queue. ... is Aaron Sorkin that dumb or does he think that we ...
(rec.music.artists.springsteen)