Hello, I’m getting an exception in the activity invoke VBA inside Excel Application Scope: Exception from HRESULT: 0x800AC472.
The excel file is stored in Sharepoint and I tried to invoke the macro by using a .txt file and also .bas file. Nothing works. I tried to kill the excel process before running the activity in order to ensure that this is not a excel memory problem.
I tried Execute Macro activity instead of Invoke VBA and I had the same problem
Nothing works.
Any ideas?