Re: Loading Excel COMs

On 10 Jul 2005 08:58:20 -0700, kumagora1@xxxxxxxxxxx wrote:

¤ 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?

Can you post a snippet of code so we can see what you are doing?


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages

  • Re: DSN-Less Excel connection
    ... Unigraphics NX is a high end solid modeling CAD/CAE/CAM ... I am currently trying to work with CDaoDatabase and ... > ¤ so I will try this question here... ... I'm trying to make a DSN-Less Excel ...
    (microsoft.public.vb.database.dao)
  • Re: ADO to connect to Excel Worksheet - ERROR
    ... the workbook was created in Excel 2000. ... I am just accessing the code via Excel 2003 on my new computer. ... > ¤ (This is a reproduction of a post that I made in the Office VBA forum, ... Dim dbConnection As ADODB.Connection, ...
    (microsoft.public.vb.database.ado)
  • Re: Copy all records from access MDB to others via ADONET
    ... it seem some caching of the csv file. ... now fixing the caching somehow:) ... I see them in Excel and MDB, ... ¤ I'm creating XLS and XSV through ADO itself. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Copy all records from access MDB to others via ADONET
    ... I see them in Excel and MDB, not in csv. ... ¤ I'm creating XLS and XSV through ADO itself. ... Dim AccessConn As New ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Using Excel Files in VB 6.0
    ... ¤ instance of Excel be present on the PC? ...
    (microsoft.public.vb.general.discussion)
Loading