My requirement is to run an excel macro and generate some files. I have a batch file which would open this Macro Enabled workbook. Within the workbook i have On Open trigger set to run the code. Everything works perfectly fine in local.
I am using QS app to run this batch file. When i try to reload the QS app in hub,batch file is called and workbook is also getting opened but the macros are not getting executed. Workbook is getting locked by service account.
Does anyone faced similar kind of issue or what could be the possible cause for it?