VeryDOC Knowledge Base

I’ve just started working on a new project for which we had to dig out one of our older libraries. We wrote it to retrieve data from MS Excel workbooks using the Office interop assemblies, and thus far it has never given us issues. A slight change this time round was that we were using our library in an ASP.NET site rather than a desktop application. As a result I was faced with two errors that we’d never seen before.

Error Message:

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0×80070005 (E_ACCESSDENIED)).

Solution:

This is a COM permissions problem.

1. Start > Run > dcomcnfg (or “mmc -32″ and then add the Component Services snap-in manually if you can’t find the app under step 3)
2. Navigate to Component Services > Computers > My Computer > DCOM Config
3. Locate the MS application giving you trouble (eg: “Microsoft Excel Application” for Excel or “Microsoft Word 97 – 2003 Document” for Word)
4. Right click > Properties
5. On the security tab: Select Customize under Launch and Activation Permissions and click Edit…
6. Add the account under which the site is running (eg: Network Service) and assign Local Launch & Local Activation permissions
7. Voila!

Error Message:

[COMException (0x800a03ec): Microsoft Excel cannot access the file '<filename>'. There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.

Solution:

This seems to be an issue with Excel/Word/etc not having access to a profile when being started via the interop route.

1. Open Windows Explorer
2. Depending on whether you installed a 32bit or 64bit version of office you will need to do one  (or both) of the following:
   1. 32bit Office installation: Navigate to C:\Windows\System32\config\systemprofile
   2. 64bit Office installation: Navigate to C:\Windows\SysWOW64\config\systemprofile
3. Verify the folder "Desktop" exists (create it if it's not there)
4. Right click > Properties
5. On the security tab: Add the account under which the site is running (eg: Network Service) with default permissions (Read & execute; List folder contents; Read)
6. Voila!

Many thanks to the contributors of this discussion.

Question to doc2any Converter Command Line,
https://www.verydoc.com/doc-to-any.html

I have a win 2000 webserver. Any thoughts on how to grant ASPNET account permission to run Microsoft Word using DCOM. I know this can be done using dcomcnfg but not sure what is the right way.I do not want to mess up a production server.

------------------------------------------------------------------------------
Under DCOM Config locate “Microsoft Word Application” right click on it and go to Properties.

Under the “Security” Tab, in the “Launch & Activation Permissions” select “Customize” and Click on Edit.

Give All Permissions to the following Account
      IUSR_<Machine_Name>
      IWAM_<Machine_Name>
      ASPNET

Now try your application.

If this does not work, then create a New Windows Account on the Server, say "Word_User" and put it in Admin Group, give it Admin Permissions. Alternatively use the existing Admin account (The account Admin uses to log into the Web Server Machine). Now add this account to the List above, i.e. in DCOMConfg give this account all permissions as well.

Now Impersonate using this account for you app. For this Modify your Web.Config  and Add these Configurations

      <identity impersonate="true" userName="domain\admin_user_account" password="xyz" />

Where admin_user_account is the Login Account of Admin on the Server or the "Word_User" that you created on the Server with Admin Previlages.

------------------------------------------------------------------------------

See Also:

How to configure Office applications to run under a specific user account
http://theether.net/download/Microsoft/kb/288367.html

Microsoft Excel Application entry missing in DCOMCNFG
https://www.verydoc.com/blog/microsoft-excel-application-entry-missing-in-dcomcnfg.html