COM Error using Office 2003 PIA in ASP.Net

[staticbob]

Guys,

I am seeing a login screen when trying to launch Excel2003 from an asp.net page. I cannot loging using any of my accounts, if I cancel the login, I get the following error... on this line of code...

Line 165:        Dim oExcel As New Excel.Application

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005. 

ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user. 

To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.

Can anybody tell me what the problem is here ???

Thanks
Bob

[mendhak]

Are you familiar with modifying registry settings? You basically need to look for that CLSID in the registry, except don't use regedit. Instead, use regedt32.exe, where you can right click the CLSID folder and set permissions on it. Give the ASP.NET worker process permissions on it.

[staticbob]

Thanks Mend,

Last thing yesterday I tried this thread but it made no difference. I'll make the registry changes now, although I never had to do this on the previous IIS box ?!?

My problem is that this build has changed everywhere, its now .net2, SQL2005 on a new IIS6 box. Does all this still apply in IIS6 ? I noticed some differences when running through the above post yesterday.

Ta,
Bob

[staticbob]

Mendhak,

Tried the regedit but still getting the same login prompt, when cancelled still gives me the same CLSID error.

CLSID {00024500-0000-0000-C000-000000000046}

Anything else to try ?
Bob

[mendhak]

Sorry, that should've worked.

But I googled and found this:

http://blog.crowe.co.nz/archive/2006/03/02/589.aspx