Open Excel file

[Guest]

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/NewsletterArticle/2003/09/asp200309so_l/asp200309so_l.asp

 

[Guest]

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?