Hello,

I am trying to import/export Excel data with VB.NET based on examples I have found.  Unfortunately, Excel.Application, Excel.Workbook, and Excel.Worksheet get underlined (they are not defined).  Could you please tell me what I need to do differently?

        Dim objExcel As New Excel.Application()   ' Instance of Excel
        Dim objWorkbook As Excel.Workbook     'workbook object
        Dim objWorksheet As Excel.Worksheet     'worksheet object

I did add a reference via Project > Add Reference > selecting the "COM" tab > and then selecting "Microsoft Excel 11.0 Object Library" and clicking "ok"

I have the reference in my solution explorer window.

I haven't worked with references before, so I'm not sure what to do next.  I thought that simply by adding the reference I would be good to go but that doesn't appear to be the case.  I added the Excel 11.0 Library because I'm using Excel 2003.

Thank you in advance,
michael

I'm just a hobby programmer, so I dont know if this solution is a good one. But you can try this code instead:

Dim objExcel As New Microsoft.Office.Interop.Excel.Application    ' Instance of Excel 
Dim objWorkbook As Microsoft.Office.Interop.Excel.Workbook      'workbook object 
Dim objWorksheet As Microsoft.Office.Interop.Excel.Worksheet     'worksheet object

Regards,
Zorro

 

I must correct myself. The code must be as follow:

Dim objExcel As Microsoft.Office.Interop.Excel.Application
Dim objWorkbook As Microsoft.Office.Interop.Excel.Workbook  
Dim objWorksheet As Microsoft.Office.Interop.Excel.Worksheet   

objExcel = New Microsoft.Office.Interop.Excel.Application    ' Instance of Excel 
objWorkbook = New Microsoft.Office.Interop.Excel.Workbook      'workbook object 
objWorksheet = New Microsoft.Office.Interop.Excel.Worksheet     'worksheet object

After creating the reference the next step is to use either the fully qualified name as shown in your first response or you may use this statement...

Imports Microsoft.Office.Interop.Excel

then you may declare objects like this...
Dim wkb As Workbooks
wkb.Open(filename) Dave

U have to include the references of microsoft excel which can be done as follows:

 Project -> Add References -> com -> microsoft excel 10.0 object library

 

:)
 

 Thanks & Regards

vasu dev