Rename files based on excel worksheet list

Hi All,

Really hoping you can help here.

Each month I get a load of files which have been manually downloaded by someone else. This means that the convention is not always the same! However, there is always one part of the filename that is the same.

EG: ABC 0455805919-062.csv will be downloaded the next month as GBV 0455805919-063.csv. The first part of the name will change, and the last part after the '-' increments by 1 each month.

What i would like is some VBA to rename the files using a predetermined list.

EG, always rename any file containing "0455805919" (the middle bit of the filename above) to fileone.csv

I've played about with the 'name' option in VBA so I can rename files with , but am struggling with the changing filenames. Does anyone have any ideas that could help me? Sorry if I'm not being 100% clear!

Thanks very much.

Thanks for that, looks like exactly what i need! I'll give it a go tomorrow