Lrobinson 93181 (6/18/2013)
Ok, I now see that the "Desktop" file workaround fixes a "save as" exception, and my exception occurs when opening the Excel file. I am going to convert my excel to csv and see if that cures the problem.
Thank you for all of your help!
Hi , did you find a way to fix this ?
I am getting exactly the same error as
"Exception calling "SaveAs" with "1" argument(s):"SaveAs method of Workbook class failed"
The script runs fine outside of job agent, it creates an excel workbook, adds data to cells, saves, and closes.
-- My script also runs fine outside of an SQL agent job
-- Also tried the create Desktop folder option as listed earlier
I am not sure what this means, although it consistently fails to complete the script (for different reasons), it does appear to run the script
-- Same for me.
Appreciate any thing you found that made it work ?