auto File Save as

[mws5872]

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!

[Gabor]

Place this into a normal module of the file:

Please Login or Register  to view this content.

On opening the file the above macro should run and will offer the user to save the file under filename & Date.
Will be saved into same directory.
I hope this helps.