Calling Excel 2000 from ASP on IIS 6

[jostein67]

I have moved an ASP application to a new Windows server. Need to export data to Excel. Worked fine before. Not so anymore.

Case:
- Exporting data from ASP to Excel 2000, using Office Web Components.
- Installed and reinstalled Excel, also checking that MSOWC.DLL is in the right spot on my disk.
- Old server Win 2000/IIS 5, new server Win2003/IIS 6.
- Have selected ALLOWED for all Web Extensions in IIS Manager (all ISAPI, all CGI, ASP, ASP.NET, etc.)
- Also specified that ASP in particular should be allowed to run ALL Web Extensions
- Used DCOM Config (dcomcnfg.exe) to set authorization to ”None” for the Excel DCOM-object
- Also tried to tell DCOM to run Excel on the old server (where things used to work) and not on the local computer

The Excel object is made like this:
Set objSpreadsheet = Server.CreateOb ject("OWC.Sprea dsheet") (works OK)

The link and export is done like this:
<a target="_blank" href='xls/<%=etype%>_<% =session("filena me")%>?Nocache="<%= server.URLencod e(now())%>"'><b >Download to Excel</b></a>
session("save") = Server.MapPath( "xls/") & "\" & etype & "_" & session("filena me")
objSpreadsheet. ActiveSheet.Exp ort(session("sa ve"))

Error msg (points to the last line above, trying to export the data):
Microsoft Office Web Components 9.0 error '80070005'
Cannot start Microsoft Excel. Click OK, and make sure you can run Excel. If you can't, uninstall and then reinstall Excel. Then try exporting again.

Like I said, reinstall of Office is something I tried. Like everything else I know, or rather don't know, anything about.

Session(”filena me”) (in bold in my code sample) is blank. On the old server this was an 8- or 9-digit number with the .XLS extension. Session(”filena me”) is not set anywhere in my code, so it must come from the Excel-object...

Please!!

Jostein