I have several automations published on TIC currently. Most follow the process of running one or more queries, export the data to a single Excel file, then call an Excel macro within that file which further summarizes the data and sends out an email (using CDO messaging). To date, all of the other automations of this type have worked successfully.
This latest one, however, starts the update process by running three queries, and exporting the data to the Excel file. This works fine. Then the process does not move forward - the excel file is left open indefinitely (I have to end the Excel process with the Task Manager) - it does not appear that the macro is ever initiated, as even the first statement is not executed.
This same automation has worked fine many times when I run it on my desktop, but operates as noted above when published to TIC.