Excel File

[jessi]

Hello,

I need to open an excel Workboot from an existing excel file, but I get the
following error:

Old format or invalid type library

Here is my code:

Dim oExcel As Excel.Application
oExcel = New Excel.Application
Dim oWorkbook As Excel.Workbook
oWorkbook =
oExcel.Workbooks.Open(Filename:=Request.ServerVariables("APPL_PHYSICAL_PATH")
& "otrapruebamas.xls") 'This line generates the exception
Dim x As String = oWorkbook.Worksheets(1).Range("A1").Value

I need help, thanks!!

 

[NickHK]

Is this supposed to be in VBA or ASP ?
Or one of the .Net languages ?

It's not valid VBA.

NickHK

 

[jessi]

In Asp.Net 1.1 using VB.NET

Is this supposed to be in VBA or ASP ?
Or one of the .Net languages ?

It's not valid VBA.

NickHK

 

[NickHK]

You will probably get more meaningful responses in one of the groups that
deals with Interop/Net.
A complete guess, but are there limitations of which versions of Excel can
work with versions of the .Net framework ?

NickHK

 

[jessi]

Solution:

System.Threading.Thread.CurrentThread.CurrentCulture =
System.Globalization.CultureInfo.CreateSpecificCulture("en-Us")

Dim oExcel As Excel.Application

oExcel = New Excel.Application

Dim oWorkbook As Excel.Workbook

oWorkbook =
oExcel.Workbooks.Open(Filename:=Request.ServerVariables("APPL_PHYSICAL_PATH")
& "otrapruebamas.xls")

Dim x As String = oWorkbook.Worksheets(1).Range("A2").Value