Auto Update Data excel Task Schedule

[izk630]

Hey guys,
This is a tricky one.

I work with a certain spreadsheet that needs data updates every hour. I am able to set the windows task scheduler to open the spreadsheet every hour, and was able to enable the option to automatically refresh the data every time it opens. What I cant get windows to do is to save the spreadsheet and close it. can I do this with a macro? and if so I do not want my spreadsheet top open save and close when I open it manually to make edits. Only when the task scheduler opens it.

Thanks,

[dflak]

I have so many reports that I need to run using the task scheduler that I had to set up a system to mass produce them. The following article explains the system I use. Basically I copy a template script to a descriptive file name such as Run XYZ.xlsm. Then I "fill in the blanks" in Run XYZ.xlsm. One of the lines the script produces is the program string to copy and paste into the task scheduler. So the task scheduler runs the script which in turn runs the macro in the target report.

Make sure the script and the target report are in trusted locations. I keep all my scripts in one directory and my reports are in sub-folders in a report directory.

http://www.utteraccess.com/wiki/inde...a_Macro_to_Run