Many thanks once again for the follow-up.   Unfortunately, using "Application.displayalerts=false" also prevents SAS add-in dialogs from running (e.g. "running analytics" on a report, "opening report", and other alerts). Preventing these dialogs seems to prevent the report from being processed...   If there are any ways to specifically force the "errors downloading report" dialog box to select "continue", it will be the way to automate this report.   Cheers. ... View more

Many thanks for writing back.   Regarding "Application.DisplayAlerts = False", am afraid it would not work in this case as we need to allow other SAS add-in pop-ups (i.e. database connection, loading report status, etc.)   Goal here is to automate the production of SAS reports via the Excel add-in. Note that  issues are expected and we always want to ignore them and continue to produce the report. This will only be possible if we can disable that particular pop-up "errors downloading the report" or find a way to bypass it, automatically click "continue", etc.   Cheers. ... View more