Hello Mark,

One way to handle this would be to create a monitor all adapter for C:\*FILEPATHHERE*\Excel.EXE and have it click whichever button you need to click when that window's created event is fired. You should be able to interact with and interrogate that popup as it is a generic windows popup contained in the Excel application and not part of the excel application itself.

A better solution, would probably to be to rather than deal with this Robotics solve the issue that causes this popup to appear. Information on how to do that can be found here: https://support.office.com/en-us/article/enable-or-disable-macros-in-office-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6