We are migrating from Excel Eikon to Excel Workspace. Currently, we are using a C# program to automate the process. However, while we can load the Excel Add-in in Eikon, we are unable to load the add-in after switching to Workspace.
Here is a sample of our C# code:
using Excel = Microsoft.Office.Interop.Excel;
Excel.Application objApp = null;
objApp = new Excel.Application();
objApp.DisplayAlerts = true;
objApp.Visible = true;
The Excel process runs, but it does not load the Workspace add-in tab. After checking the add-in status, it shows the error: "Not loaded. A runtime error occurred during the loading of the COM add-in."
Is there any way to solve this issue? After searching in the forum, I think my case is similar to this one. Thank you.
