Excel 11 Type library for VB.NET?

[Mansour]

Dear Friends,

I'm developing a VB.NET 2005 project in windows VISTA.

I add reference to Excel 11 (2003) type library.

My reference seems to be made to Excel.exe and declaration appears as below:

Dim myExcel As Microsoft.Office.Interop.Excel.Application

but it returns exception when I try to cast excel into it as below:

myExcel = GetObject(, "Excel.Application") or myExcel = GetObject(,
"Excel.Application.11")


If I change my delaration to

Dim myExcel As Object

everything goes well for a while but I cannot access most of Excel object
library's properties (such as Activeworksheet.cells(2,2).value) which were
all visible to me in VB6.

Any help would be highly appreciated.

Kind Regards,
M. Ramezani

 

[Vergel Adriano]

Hi,

Try something like this. It will create a new workbook and save it in the
root of drive C:.

Dim myExcel As New Microsoft.Office.Interop.Excel.Application
Dim wb As Microsoft.Office.Interop.Excel.Workbook

wb = myExcel.Workbooks.Add()
wb.SaveAs("C:\test.xls")
wb.Close()
myExcel.Quit()