Open Excel form an aspx page

[Guest]

I want to open Excel from an aspx page, put some records in there, format
them and close the excel file. I can't open the Excel application.

It says Cannot create ActiveX component.
Here is the code:

Imports Excel = Microsoft.Office.Interop.Excel

Public Class MG
Inherits System.Web.UI.Page

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim oExcel As Object
oExcel = CreateObject("Excel.Application")
End Sub
End Class

Can anyone tell me what to do?

 

[Lars-Erik Aabech]

Correct syntax with the PIA would be

Dim excel as Excel.ApplicationClass
Set excel = new Excel.ApplicationClass()

Be aware though, that Excel can't be killed from ASP.NET, at least as far as
I've experienced. See my post in this forum posted 2004.09.10 10:49...

You can find lots of resources about office interop here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_oxppias.asp

Good luck

L-E