Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excell 11 Type library for VB.NET 2005

0 views
Skip to first unread message

Mansour

unread,
Oct 8, 2008, 7:05:01 PM10/8/08
to
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

0 new messages