Excel update links, run macros, save as web

I want to open a spreadsheet, update all links, run all macros and save as a web on a one hour timer.
First how? and second should some of this occur as a macro in Excel?
dzelniko