Automated Report Scheduler

hellfire45

Active Member
Joined
Jun 7, 2014
Messages
447
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!
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,118,855
Messages
5,574,677
Members
412,611
Latest member
MattDexx
Top