locked
Problem with Interop.Excel new ApplicationClass() from remote computer with MS Office 2003 RRS feed

  • Question

  • User455386564 posted

    I am using Microsoft.Office.Interop.Excel 12.0 version to automate excel in my web application (where i am using ASP.NET with C#.NET). It is raising an exception when i am trying to create new ApplicationClass() before creating a file/Excelsheet with a given path..It is working properly when there is  a file existing already with same path..

    But when i've to create a new file it is raising exception.

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

    That too this is happening only when the client system has MS Office 2003. The same is working normally in my system(server) which has MS Office 2007.

    Entire thing is very much confusing.

    Quick solutions are higly apreciated.

    Thursday, January 7, 2010 1:48 AM

All replies

  • User-1659704165 posted

    Hi,


    Seems to me DCOMCNFG problem an persssion of IIS user if u have Installed Office Automation

    http://it.toolbox.com/blogs/coding-dotnet/setting-excel-application-to-run-under-the-interactive-user-account-8588

    http://www.codeguru.com/forum/printthread.php?t=383912&page=3&pp=15


    Thursday, January 7, 2010 4:56 AM
  • User455386564 posted

    Thank You Avinash for responding so quickly, if it is problem with DCOMCNFG can we apply the same for MS Word, I have read in many forums and even in MSDN that ASP.NET does not support Office Automation and there is possibility for malfunctioning any where.

     In fact i had not tried your suggestion, as i am unable to find Microsoft Excel 97/2000/2002 - Microsoft Excel Application in DCOMCONFIG applications list. May be that is because i dont have permissions or will be different for XP.


    Tuesday, January 12, 2010 6:02 AM
  • User-2119480821 posted

    All the installations you using while developing on local system.. needs to also installed on your server.

    Tuesday, January 12, 2010 6:10 AM