I have a simple automation which opens a workbook and then proceeds to run a macro within the workbook. However the workbook contains links which causes a pop up when the excel document opens. (See screen shot)
I need to bypass this within the automation i.e. hit "Don't update" for the automation to complete. Can anyone recommend how I can do this?
You would need to interrogate that window in Excel (or at least see if you are able to). To do that, you'd need to create an adapter whose StartMethod is set to MonitorAll and whose Path is set to Excel.exe. This is because your connector is actually going to be starting Excel, so yor adapter cannot use any other StartMethod.