Invoke vba eror

[lojyehuang (Lo-Chieh)]

@Duygu_Ozdemir
You can check this topic and check loop code in your VBA.
The only way around that is going to be to make your object model call from a loop. You will need to continue to retry the call until it succeeds–so you’ll set a success bit right after the call and then have an exception handler that catches (and eats) the 0x800AC472 exception which allows the loopback to continue.

Invoke VBA: Exception from HRESULT: 0x800AC472

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?

https://social.msdn.microsoft.com/Forums/vstudio/en-US/9168f9f2-e5bc-4535-8d7d-4e374ab8ff09/hresult-800ac472-from-set-operations-in-excel