VBScript code snippet below is being used in an ASP page but the call to GetObject never attaches to a running instance of
Excel. Since visible property is set to True, I can see the instances accumulate in the TaskBar each time the ASP page is
called, so there are obviously instances to attach to.
Set excelApp = Server.GetObject(,"Excel.Application")
If (err 0) Then
Set excelApp = Server.CreateObject("Excel.Application")
excelApp.UserControl = True
excelApp.Visible = True
excelApp = Nothing
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
GetObject errors out with the following error:
Error - Number:429 Source:Microsoft VBScript runtime error
Description:ActiveX component can't create object
Any ideas why?
Have tried everything I can think of
and every permutation and example I have found online while researching this. Any ideas?
Running Excel 2003 on IIS
6 and Windows Server 2003.
PS. If this post is off topic for this forum, any suggestions where I could ask it?