Unable to automate pop up dialogues

[Anonymous]

Hi I am new on BP and I'm struggling to find an action that can automate pop up dialogues in the MS Excel VBO. I have to frequently click update as I run the process. Can you advise on how to handle this?

[John__Carter]

Hi the Excel VBO is basically a wrapper for the Excel VBA API. The scope of the API is huge and the object only covers the basics for RPA. There are two option, 1) create new functionality using the VBA API or 2) create a new object that spies Excel as a thick client application.