I would suggest you to handle the popup with Excel Macro code separately and then try to open with Automation Anywhere.
You can try with recorder as well. It might help.
Can you please share the popup screenshot for better understanding?