Getting the below exception while accessing Excel using Microsoft Interop - running application from Task Scheduler (Under Run whether user is logged on or not)

Question

Exception :

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)).

Stack Trace : at System.Runtime.Remoting.RemotingServices.AllocateUninitializedObject(RuntimeType objectType)

at System.Runtime.Remoting.Activation.ActivationServices.CreateInstance(RuntimeType serverType)

at System.Runtime.Remoting.Activation.ActivationServices.IsCurrentContextOK(RuntimeType serverType, Object[] props, Boolean bNewObj)

at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)

at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)

at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)

at System.Activator.CreateInstance(Type type, Boolean nonPublic)

at System.Activator.CreateInstance(Type type)

Answer 1

I have a c# program running as a service on my windows 11 PC (for about 9 months now). But since the weekend I get this error. Error Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)).

This is my code

            Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();

            Microsoft.Office.Interop.Excel.Workbook xlWorkBook = xlApp.Workbooks.Open(@"C:\Dealer Limits.xlsb", ReadOnly: true);

            Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet = xlWorkBook.Worksheets["Limits"];

            xlApp.Run("LoadDataFromExcelToSQL");

Answer 2

This error message indicates that the COM class factory for the specified CLSID failed to be retrieved due to a server execution failure.

Could you share some screenshot of your issue. It is hard to say what happen whithout enviroment at hand.

Then we may give suggestions on it.