Saving a sheet with today's date

Is there a clever way to save the spreadsheets I create via my macros with today's date at the end of the file name? For example, "PM Report 02-08-11"?

This would allow me to save the files directly to our intranet and cut out a lot of manual work that is still needed after all the macros are complete.

I know you're going to say no though, aren't you? ;-)

Ignore the above I've found a way to do this (easy in the end) but the next question is a little more complicated:

As I can save a new file with today's date is there a way to delete or move the old file already in the folder? The file name will be in the same format but the date would be different though in the same format, e.g. 25-07-11. Is there anyway the macro could find this old file and delete it or move it?

I see backups of all reports on our network but generally only keep the latest file on our intranet, so I would need to delete the old file on our intranet and move the old file on our network.

BTW I used this code to save as with date:

Please Login or Register  to view this content.