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.ServerVari ables("APPL_PHYSICAL_PATH")
& "otrapruebamas.xls") 'This line generates the exception
Dim x As String = oWorkbook.Worksheets(1).Range("A1").Value

I need help, thanks!!

[Alexey Smirnov]

"jessi" <am****@cyc.eswrote in message
news:OW**************@TK2MSFTNGP03.phx.gbl...

>
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.ServerVari ables("APPL_PHYSICAL_PATH")
& "otrapruebamas.xls") 'This line generates the exception
Dim x As String = oWorkbook.Worksheets(1).Range("A1").Value

BUG: "Old format or invalid type library" error when automating Excel
http://support.microsoft.com/kb/320369

[Mark Rae]

"jessi" <am****@cyc.eswrote in message
news:OW**************@TK2MSFTNGP03.phx.gbl...

Hello,

Dim oExcel As Excel.Application

Excel, as with the rest of Office, is not designed for server-side
automation. Microsoft strongly disadvises this, and won't actually support
any application which uses it:
http://support.microsoft.com/default...US;q257757#kb2

Use this instead: http://www.aspose.com/Products/Aspos...s/Default.aspx

[jessi]

Solution:

System.Threading.Thread.CurrentThread.CurrentCultu re =
System.Globalization.CultureInfo.CreateSpecificCul ture("en-Us")

Dim oExcel As Excel.Application

oExcel = New Excel.Application

Dim oWorkbook As Excel.Workbook

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

"Mark Rae" <ma**@markNOSPAMrae.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

>
"jessi" <am****@cyc.eswrote in message
news:OW**************@TK2MSFTNGP03.phx.gbl...

>Hello,

>Dim oExcel As Excel.Application

Excel, as with the rest of Office, is not designed for server-side
automation. Microsoft strongly disadvises this, and won't actually support
any application which uses it:
http://support.microsoft.com/default...US;q257757#kb2

Use this instead: http://www.aspose.com/Products/Aspos...s/Default.aspx

[Mark Rae]

"jessi" <am****@cyc.eswrote in message
news:u$**************@TK2MSFTNGP02.phx.gbl...

Solution:

System.Threading.Thread.CurrentThread.CurrentCultu re =
System.Globalization.CultureInfo.CreateSpecificCul ture("en-Us")

Dim oExcel As Excel.Application

oExcel = New Excel.Application

Dim oWorkbook As Excel.Workbook

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

You'll be *very* fortunate indeed if this works in a live production
environment...

It almost certainly won't...

[jessi]

Why?


"Mark Rae" <ma**@markNOSPAMrae.comwrote in message
news:Ow**************@TK2MSFTNGP03.phx.gbl...

>
"jessi" <am****@cyc.eswrote in message
news:u$**************@TK2MSFTNGP02.phx.gbl...

>Solution:

System.Threading.Thread.CurrentThread.CurrentCult ure =
System.Globalization.CultureInfo.CreateSpecificCu lture("en-Us")

Dim oExcel As Excel.Application

oExcel = New Excel.Application

Dim oWorkbook As Excel.Workbook

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

You'll be *very* fortunate indeed if this works in a live production
environment...

It almost certainly won't...

[Mark Rae]

"jessi" <am****@cyc.eswrote in message
news:eP**************@TK2MSFTNGP06.phx.gbl...

Why?

For precisely the reasons outlined by Microsoft in the link that I gave you
in my first reply...

Is there any particular reason why you didn't read it...???

[sloan]

Jessi.

Mark is trying to help you, by giving you a article about ~why not to do
this.

Instead of asking "why", try reading the article.... and then if you need to
ask specific questions about the the article, then do so.

But put a little legwork in...esp when someone is trying to ~help you avoid
a pitfall.


"Mark Rae" <ma**@markNOSPAMrae.comwrote in message
news:ex**************@TK2MSFTNGP03.phx.gbl...

"jessi" <am****@cyc.eswrote in message
news:eP**************@TK2MSFTNGP06.phx.gbl...

Why?

For precisely the reasons outlined by Microsoft in the link that I gave

you

in my first reply...

Is there any particular reason why you didn't read it...???