Open Excel file

[Micke]

I'm trying to open an Excel file from a code behind page to an aspx page. I'm
getting the eror message:
System.Runtime.InteropServices.COMException: Old format or invalid type
library

My code is:

Dim oExcel As New Excel.Application
Dim oBooks As Excel.Workbooks
oBooks = oExcel.Workbooks
oBooks.Open("C:\Test.xls")

At the top I have
Imports Excel = Microsoft.Office.Interop.Excel
and I have set a reference to the Microsoft Excel 11.0 Object library

Anyone have any suggestion?

[Steve C. Orr [MVP, MCSD]]

This article contains the information you need to work with Excel files from
ASP.NET:
http://www.aspnetpro.com/NewsletterA...200309so_l.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Micke" <Mi***@discussions.microsoft.com> wrote in message
news:38**********************************@microsof t.com...

I'm trying to open an Excel file from a code behind page to an aspx page.
I'm
getting the eror message:
System.Runtime.InteropServices.COMException: Old format or invalid type
library

My code is:

Dim oExcel As New Excel.Application
Dim oBooks As Excel.Workbooks
oBooks = oExcel.Workbooks
oBooks.Open("C:\Test.xls")

At the top I have
Imports Excel = Microsoft.Office.Interop.Excel
and I have set a reference to the Microsoft Excel 11.0 Object library

Anyone have any suggestion?

[Micke]

Thanks,
I have followed the first example but it always ends up with:
System.Runtime.InteropServices.COMException: Old format or invalid type
library

Any hints?

"Steve C. Orr [MVP, MCSD]" wrote:

This article contains the information you need to work with Excel files from
ASP.NET:
http://www.aspnetpro.com/NewsletterA...200309so_l.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Micke" <Mi***@discussions.microsoft.com> wrote in message
news:38**********************************@microsof t.com...

I'm trying to open an Excel file from a code behind page to an aspx page.
I'm
getting the eror message:
System.Runtime.InteropServices.COMException: Old format or invalid type
library

My code is:

Dim oExcel As New Excel.Application
Dim oBooks As Excel.Workbooks
oBooks = oExcel.Workbooks
oBooks.Open("C:\Test.xls")

At the top I have
Imports Excel = Microsoft.Office.Interop.Excel
and I have set a reference to the Microsoft Excel 11.0 Object library

Anyone have any suggestion?