I have a VB script on an application server to open an .xlsm, and run a function which does the following:
- Open an Excel file with a OLEDB connection
- Refresh the connection
- Save and close
When running manually, everything works as designed. However, when running in Task Scheduler as a specific user whether logged in or not (with password and highest priv, also both folders are on the server).
From my simple logging method, I can tell that it's failing on the "Refresh" step
In the data source settings, I'm using database credentials, and am passing through the UID/PWD through the connection string.
Any help/advice you all could provide would be greatly appreciated.
d6ssm.png
rnO72.png
kFb6A.png
Bookmarks