Rename Part of All Files in Folder

[fervorking]

I'm having trouble changing part of the file name for all the files in a particular folder. What I want to do is have an Input Box appear that I can input the current week. The macro will then find last week's number in the file name and replace it with the current number. The part I'm having trouble with is all the file names are slightly different. Here are file names: Week 21 Monday.xls, Week 21 Tuesday.xls, etc. for each day of the week.

I need a macro to change the numerical part of the file only with the number I input into the Input Box. Any help is greatly appreciated. I'm really close, but I cannot get this last part to work.

[MarvinP]

http://www.codejacked.com/renaming-m...-once-windows/ or
http://dos.software.informer.com/dow...ing-wildcards/

[davegugg]

You can use the Replace function for that. It'd be something like this, looped over each file name:

Please Login or Register  to view this content.

[fervorking]

You can use the Replace function for that. It'd be something like this, looped over each file name:

Please Login or Register  to view this content.

How would I do that? I only know For-Next loops (pretty new to VBA).

[fervorking]

Nevermind. I figured it out using a Do While. Thanks for the help.