hellfire45
Active Member
- Joined
- Jun 7, 2014
- Messages
- 462
Hi Guys,
At my old company I used to have this MS Access database where you could load hundreds of reports and by indicating the file path of the file and the "start module" in that workbook, as well as the days of the week, the reports would fire off and process in sequential order. They would be triggered by a file published by IT that would let the MS Access database know when the nightly loads were done.
That workbook no longer works since I have changed companies.
Does anybody know of anything like this that I can use? It's basically become pretty burdensome to sit and "click run buttons" in the morning. It eats about an hour of my day. I'd like to just load these automated excel workbooks and have them kick off sequentially starting at about 6am.
Anybody have any ideas of something I could use that would be helpful? Is Windows Task Scheduler the only option? Thanks a tons!
At my old company I used to have this MS Access database where you could load hundreds of reports and by indicating the file path of the file and the "start module" in that workbook, as well as the days of the week, the reports would fire off and process in sequential order. They would be triggered by a file published by IT that would let the MS Access database know when the nightly loads were done.
That workbook no longer works since I have changed companies.
Does anybody know of anything like this that I can use? It's basically become pretty burdensome to sit and "click run buttons" in the morning. It eats about an hour of my day. I'd like to just load these automated excel workbooks and have them kick off sequentially starting at about 6am.
Anybody have any ideas of something I could use that would be helpful? Is Windows Task Scheduler the only option? Thanks a tons!