I currently have some daily reports I wrote that generate and email out Excel reports for orders and shipments. They work fine when run manually, but when I put them to run in a scheduled task they will not run. The script fails at these lines of code:
Everything is properly dim'ed, but I am still keep getting 424 "Object Required" Errors.
I suspected a security issue as the user running the reports in the scheduled task is limited in its rights. But if I log on as that user and manually run the scripts it works fine, only in the scheduled task is this error coming up.
Any assistance would be greatly appreciated, I've tried most everything I could think of.
Matt Laski
Web & Systems Support
Pulsafeeder Inc.
Code:
Set objXL = Wscript.createobject("Excel.Application")
set objXLbook = objXL.Workbooks.Add
Everything is properly dim'ed, but I am still keep getting 424 "Object Required" Errors.
I suspected a security issue as the user running the reports in the scheduled task is limited in its rights. But if I log on as that user and manually run the scripts it works fine, only in the scheduled task is this error coming up.
Any assistance would be greatly appreciated, I've tried most everything I could think of.
Matt Laski
Web & Systems Support
Pulsafeeder Inc.