Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsVB SyntaxEnterprise DevelopmentDatabase AccessControlsCOMWin APICrystal ReportDeploymentGeneralGeneral 2
Related Topics
VB.NET / ASP.NETMS SQL ServerMS AccessOther Database ProductsMore Topics ...

VB Forum / COM / September 2005



Tip: Looking for answers? Try searching our database.

Loading Excel Ref Library

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kumagora1@comcast.net - 24 Sep 2005 04:01 GMT
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..

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.