I'm attempting to teach myself automation of Excel 2003 using Visual
Studio.Net 2003.
I did Project--->Add Reference and loaded both Excel 11.0 Object
Library and Excel 5.0 Library. When I attempt to dim objExcel as New
Excel.Application, I get error saying type Excel.Application is not
defined.
But Excel IS installed.... I use it all the time. When I go to
Help--->About--->System Summary--->Office 2003
Applications--->Microsoft Excel 2003---Summary, it says I have Version
11 Build 6355.
Can somebody point me in the right direction what I'm doing wrong?
Ken Halter - 24 Sep 2005 04:48 GMT
> I'm attempting to teach myself automation of Excel 2003 using Visual
> Studio.Net 2003.
>
> Can somebody point me in the right direction what I'm doing wrong?
You'll have better luck getting .Net answers in a .Net group.
They all contain "dotnet" or "vsnet" in their names.
This and all other groups on the MS server that start with
"microsoft.public.vb" are for VB Classic (VB versions 1-6) and were in
existance long before any .Net products were released. While some of the
code looks the same, they are very different products and require a
different set of groups.
Try one of these:
news://microsoft.public.dotnet.general
news://microsoft.public.dotnet.languages.vb

Signature
Ken Halter - MS-MVP-VB - http://www.vbsight.com
DLL Hell problems? Try ComGuard - http://www.vbsight.com/ComGuard.htm
Please keep all discussions in the groups..