Iam getting this error when iam running macro in uipath

Help Activities
, ,
1

I am executing macro within excel application scope but got the below error:

Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.Office.Interop.Excel._Workbook’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208DA-0000-0000-C000-000000000046}’ failed due to the following error: System call failed. (Exception from HRESULT: 0x80010100 (RPC_E_SYS_CALL_FAILED)).

RemoteException wrapping System.InvalidCastException: Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.Office.Interop.Excel._Workbook’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208DA-0000-0000-C000-000000000046}’ failed due to the following error: System call failed. (Exception from HRESULT: 0x80010100 (RPC_E_SYS_CALL_FAILED)).
at UiPath.Excel.Activities.ExecuteMacro.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at UiPath.Executor.BaseRunner.EndExecute(IAsyncResult result)
at UiPath.Executor.InProcessRunner.EndExecute(IAsyncResult result)
at UiPath.Core.Activities.ExecutorInvokeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

i tried all the ways no use

2

Hi @T_Y_Raju ,

Troubleshooting Steps

  1. Check Excel Application Scope:
  • Ensure that the Excel application is properly opened and that the workbook is correctly loaded within the Excel Application Scope.
  1. Check Macro Name:
  • Ensure that the macro name is correctly specified and that it exists within the workbook.
  1. Close Excel Instances:
  • Before running the automation, make sure all instances of Excel are closed. Use the Kill Process activity to kill any running Excel processes.
  1. Update UiPath.Excel.Activities Package:
  • Ensure that you are using the latest version of the UiPath.Excel.Activities package.
  1. Repair Office Installation:
  • There might be an issue with your Office installation. Repairing Office can sometimes resolve COM-related issues.
    Regards
    Sandy
3

@T_Y_Raju check the below thread.