Invoke vba eror

[Duygu_Ozdemir (Duygu Özdemir)]

Hi,
Invoke VBA: Exception from HRESULT: 0x800AC472

I get this error. What do you think is the solution?
In my previous project, I was getting an error in the invoke vba section, and I mentioned it below.

Invoke VBA: Unable to run macro ‘GetColumnsCount’. The macro may not be in this workbook, or all macros may be disabled.

[Gokul001 (Gokul Balaji)]

Hi @Duygu_Ozdemir

Kindly try with WORKBOOK ACTIVITIES with READ RANGE ACTIVITY instead of EXCEL APPLICATION SCOPE and try once

Hope it will help you

Regards
Gokul

[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