Hi, I am trying to learn how to integrate excel macros in uipath. but i am getting this error , I tried updating excel packages, imported interop services.
Are you using more than one excel scope?
No only one excel application scope
Usually HRESULT is a message identifier , and happens with in excel . Did you try executing the macro in the excel itself without UiPath and check If there any errors in macro ?
yeah, able to run the macros in excel. even i tried just printing message box in macro itself not working in uipath
Can you send the package including the macro
ExecuteMacro_Example.zip (13.2 KB)
No Error for me , i can see the message box and execution ended successfully
Please check if you have these setting in your excel options ,
Yes , that should be fine
but now also not working …same exception only
whether i need to add any import statements?
Can you do Read or Write operations using Excel Application Scope?
yeah, i am able to do operations using excel application scope