Download and send by mail

Hello,
I need to download some files from a web page that are in excel, then open and update an excel macro, and finally send it by mail, this every hour. How can I do it?