View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_14_] Bob Phillips[_14_] is offline
external usenet poster
 
Posts: 216
Default Saving a file to have the filename of the dated it was created

See response in public.excel

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Dave" wrote in message
ups.com...
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