Excel Macro Error: The remote Procedure call failed (Exception From HRESULT: 0x800706BE)

Getting the following error when running a job

image

Running Windows 10 20H2 [Version 10.0.19042.1052]
Running Office 365 x64 build 2008, Build 13127.21668 C2R
Running UiPath Studio 19.10.1

Attempted

  1. Deleted HKEY_CLASSES_ROOT\TypeLib{00020813-0000-0000-C000-000000000046} 1.9 Folder
  2. Repaired Office
  3. Ignored DDE within Excel
  4. Added Delays

Still getting the same error

Hi @DTSE

Welcome to the community

Did your macro have pivots or the macro have large data in it, if it has please remove and try again.

Thanks

1 Like

Hi @DTSE ,

You can follow below steps:

1 Try to use kill activity before executing macro.

2 Put your excel application scope in retry scope.

3 Macro functions should have proper exception handling.

Just to want to know is this error occurring everytime or usually it occurs.

1 Like

Thanks for the suggestion. I will check this and get back to you.

These are great tips. We will try and let you know if it will work. Thank you very much!

1 Like