I am trying to find a way to build a macro/VBA that will save a file with a date in the file name automatically. The file itself when downloaded from the system will always be the same. postingcheck.xls and it downloads into the same directory everyday. If there was a way to add a date for example postingcheck06042009.xls ( or any other date format) that would be ideal. Any help is appreciated. I am a bit new to VBA, I am more familar with macros but I can give it a go.

thanks!