Can't open object using .aspx file. Can open with .htm file 1

[sabev]

I’m trying to use vbScript to open an excel application (I’m also going to do word).


Sub Btn1_onclick()
call OpenWorkbook("c:\temp\test.xls")
End Sub

Sub OpenWorkbook(strLocation)
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = true
objExcel.Workbooks.Open strLocation
objExcel.UserControl = true
End Sub

This code works in a .HTM file but not an .aspx file.

I get this error -

Microsoft VBScript runtime error: ActiveX component can't create object: 'Excel.Application'

Why wouldn't it work in an .aspx file?

 

[BobRodes]

Try asking this question in the ASP.Net forum. Aspx files are .Net driven, and they ought to be able to help you there.

 

[sabev]

Thanks, I fiqured it out. It was a browser security issue when run in debugger.