Loading Excel COMs

From: kumagora1@xxxxxxxxxxx
Date: 10 Jul 2005 08:58:20 -0700

I'm teaching myself how to automate Excel. I created a reference to
Excel's COM libary using the "Add Reference" pick from the Project
Menu. I selected Excel 11 Object libary which is what Excel 2003 uses,
and added it to list of selected components in Add Reference Dialog
Box.

But when I try to call Excel objects via click event from form, I get
error that says "Type Excel Application Not Defined" even though I
dim'd new object as Excel.Application and got it loaded in my reference
libary.

Workstation is Win XP and Visual Studio.Net 2003. Anybody got any idea
what I'm doing wrong and how to fix it?

.

Follow-Ups:
- Re: Loading Excel COMs
  - From: Paul Clement

Prev by Date: Is there an easy way to expose class variables in COM builds?
Next by Date: Re: Loading Excel COMs
Previous by thread: Is there an easy way to expose class variables in COM builds?
Next by thread: Re: Loading Excel COMs
Index(es):
- Date
- Thread

Relevant Pages

Re: VS2005 vb.net DLL - interop EXCEL
... where you are actually working with Excel via ComInterOp ... .NET CLR to release it's reference to the underlying COM object: ... Dim xlAppl As Excel.Application ... It has to do some work with Excel files, so I created a DLL in VS2005. ...
(microsoft.public.dotnet.languages.vb)
Re: VS2005 vb.net DLL - interop EXCEL
... an explicit Worksheet object reference and don't actually get a Worksheet, ... Dim xl As New Excel.Application ... 'Set up explicit Excel object references... ... xlSheet = xlSheets ...
(microsoft.public.dotnet.languages.vb)
Re: VS2005 vb.net DLL - interop EXCEL
... Dim xl As New Excel.Application ... 'Set up explicit Excel object references... ... xlSheet = xlSheets ... 'This causes the COM reference counts to go to zero and then COM will ...
(microsoft.public.dotnet.languages.vb)
Re: VS2005 vb.net DLL - interop EXCEL
... Dim xl As New Excel.Application ... 'Set up explicit Excel object references... ... xlSheet = xlSheets ... 'This causes the COM reference counts to go to zero and then COM will ...
(microsoft.public.dotnet.languages.vb)
Re: Workbook code works on my machine but noy others
... MsgBox "You are using Excel 2007." ... Outlook reference in the project, I had to define each constant. ... Microsoft Office 10.0 Object Library ...
(microsoft.public.excel.programming)