I’ve been trying to get an excel macro to run from a Gateway event script, but can only get it to work from the script console.
This is the part I’m testing:
from time import localtime, strftime
execTime = strftime("%H:%M", localtime())
if execTime == “10:25”:
system.util.execute([‘C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE’, ‘C:\data\some_macro.xlsm’])
I’ve read about the System service account not having rights to run windows applications, and I’ve tried allowing that account to interact with desktop. Also tried setting the service logon to use an Administrator account instead. Those don’t seem to work, and I didn’t see a solution to anyone’s problems.
How do you get a Gateway script to run and Excel macro?
Thanks for any help.