View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
trigunner trigunner is offline
external usenet poster
 
Posts: 1
Default saving And rename source file

Hello
I have a module that opens a master file that I get data from. is there a
way to save the file in a different location with the date at the end of the
file?
the source is
C:\Documents and Settings\My Documents\Reports\Master 2010.XLS
I would like it to be
C:\Documents and Settings\My Documents\Saved Reports\OCPOC - Master 2010 -
Date.XLS
Also if there is a file with the same date add a number of file

Thanks,