Open Excel form an aspx page

[Micke]

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.Offic e.Interop.Excel

Public Class MG
Inherits System.Web.UI.P age

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
Dim oExcel As Object
oExcel = CreateObject("E xcel.Applicatio n")
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.Applicati onClass
Set excel = new Excel.Applicati onClass()

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/de...dc_oxppias.asp

Good luck :)

L-E
"Micke" <Mi***@discussi ons.microsoft.c om> wrote in message
news:E5******** *************** ***********@mic rosoft.com...

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.Offic e.Interop.Excel

Public Class MG
Inherits System.Web.UI.P age

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
Dim oExcel As Object
oExcel = CreateObject("E xcel.Applicatio n")
End Sub
End Class

Can anyone tell me what to do?