Excel VBA Report Scheduler

[hellfire45]

Hi Guys,

I have so many automated workbooks at work that its really cumbersome to open each file, click run, go have coffee, and come back only to open and click run on the next report. I used to have a tool at my old company where you could type in the file path of the workbook, the "start subroutine" name, and the days of the week you want it run and then it would fire off at a certain time of day.

Any suggestions about similar tools that can be used to load many automated reports? I am aware of the task scheduler but I'm not sure this is the best option.

 

[Rijnsent]

The tool you describe could e.g. be an MS Access database. A while ago I built a "fax printer" for a company: they basically had to open a form in an Access database and that form would run every 1 minute a macro that would check a table to see which tasks needed to be done and would kick off those tasks. In my case: check a directory for new PDF files (incoming faxes, put there by another application) and send them to the printer. The main disadvantage: someone had to have the tool open on their PC for the macro to run.