Saving a file to have the filename of the dated it was created

I have a load of spreadsheets that I need to file in the same folder.
The problem is each one has the same filename. Does anyone know how to
save a file as the date that it was created on thus saving me having to
go through 100's of files and do it manually.

Thanks

Dave Woodgate

See response in public.excel

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Dave" <[email protected]> wrote in message
news:[email protected]...
> I have a load of spreadsheets that I need to file in the same folder.
> The problem is each one has the same filename. Does anyone know how to
> save a file as the date that it was created on thus saving me having to
> go through 100's of files and do it manually.
>
> Thanks
>
> Dave Woodgate
>