Hello,

I'm looking for a macro code that can automatically open an excel workbook at 8:00 AM in the morning and then execute a macro in the worksheet to pull the latest data. In addition, the other macro code after pulling data from yesterday, it will automatically create a new tab then you have to name the tab. I usually input yesterday's date like 12.22.13. Is there a way this macro code will be able to name yesterday's date automatically as well?

Thank you for your help.