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!!

 

[Guest]

It has to do with a locale (LCID) bug in Excel. You might solve it by
setting CurrentCulture to en-US. The following links might be of help to you:

http://groups.google.dk/group/micro...d+type+library&rnum=18&hl=da#cba96f514ad3349f

http://groups.google.dk/group/micro...d+type+library&rnum=13&hl=da#6e645f5f56732323

HTH, Jakob.

 

[jessi]

Thanks

It has to do with a locale (LCID) bug in Excel. You might solve it by
setting CurrentCulture to en-US. The following links might be of help to
you:

http://groups.google.dk/group/micro...d+type+library&rnum=18&hl=da#cba96f514ad3349f

http://groups.google.dk/group/micro...d+type+library&rnum=13&hl=da#6e645f5f56732323

HTH, Jakob.

 

[Pritcham]

It might also be to do with your use of the "Filename:=" syntax which
is specific to Excel VBA in this instance

i.e. either change your use of
oExcel.Workbooks.Open(Filename:=Request.ServerVariables.......

to something like
oExcel.Workbooks.Open("Filename:=" & Request.ServerVariables.....

or find out the order of parameters passed to the Workbooks.Open()
method and skip the "Filename:=" declaration altogether as this is
only really used if you rearrange the parameters in the method call.

hope that helps
Martin