Excel command error on EM-server

Support
1

Hi!

We’re unable to use the function “recalculate workbook” on our EM-server. because of the following error.

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: 0x80070005 (E_ACCESSDENIED)).

**Location:** action "Excel command", table "data_template.xlsx"

When researching the error we found a MSDN forum that suggested to create the directory “C:\Windows\SysWOW64\config\systemprofile\Desktop” on a 64 bit machine. But that didn’t do the trick.

Anyone have an idea on how to resolve this issue? (Excel 2016 is installed on the server)

2

Hi Emil,

Windows services have problems with running COM-automations in Windows due to a different permission set than Windows user accounts have. Maybe this link would help: Running VBA Macros from the Excel Command action

3

Hi Dmitri,

We’ve tested the recommended solution but are still encountering this issue. We’ve tried assigning correct permissions and following the steps but we keep receiving :
" 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: 0x80070005 (E_ACCESSDENIED)).

Location: action “Excel command”, table “data_template.xlsx”".

Please let me know if there’s anything you think might still be causing this issue.

Thanks in advance !
Kind regards,
Mihai

4

Hi Mihai, and welcome to the Community!

Have you tried all the solutions from the following article?
https://timwappat.info/post/2013/09/03/Solution-to-Excel-Automation-VBNETC-error-running-as-a-service-0x800A03EC-MicrosoftOfficeInteropExcelWorkbooksOpen

It mentions a different error, but from my experience, those errors have the same sources.

5

Hi Andrew,
Yes, followed the steps and assigned permissions and mysterious directory but we are still getting this issue.
Could this have anything to do with the account used to run the easymorph service on the server ?
Kind regards,
Mihai

6

Hi Mihai,

The account used to run the Easymorph service on the server should not affect the execution of the task if the task’s space is configured to use a non-default worker that in turn configured to use a Windows user account (which is the recommended way to run the Excel command action on an EasyMorph server).