I am creating reports on a weekly basis with the below filenames.

"Sample - File - 31 Jan 2011 - 04 Feb 2011.xls"

Each week the dates on the files increase and Im basically just looking to write a rename script that will only require me to fill in the current weeks dates as variables.

Each weeks files are self contained in a folder with the run date.

Previous rename scripts ive used have been somthing along the lines of. 

Please Login or Register  to view this content.
But useing this same code in this instance would require 4 variables and so Im just looking to see if anyone knows a clever way around this?

Cheers!
#Tony