Any one used Tidal job to run an Excel Macro?
I have an Excel Workbook which has a Macro set to run when the workbook is opened.
It runs without any issues when opening the file from Excel, from a batch file with Start Excel command, etc.
I need to run this Excel Macro from a Tidal job.
The Tidal job starts the excel and nothing happens after that. The Excel shows up in the Task manager and that is it.
Could it be any security warning or message box preventing the Excel to load the workbook and macro?
If so, how to prevent that?