Hi - I produce monthly reports using Word which are named using a number and initials, which always stay the same, followed by the relevant month. I would like to use a macro to update the month in all the file names while leaving the number and initials used in each file the same, possibly by using a message box to insert the relevant new month.



To illustrate what I mean, here is a list of 5 old file names followed by what I would like to change them to, if the old month was March and the new month was April (in reality I would be doing this every month for about 50 files):

Old:
2237_SH Mar 14
10681_SH Mar 14
11964_SH Mar 14
12536_SH Mar 14
13506_SH Mar 14

New:
2237_SH Apr 14
10681_SH Apr 14
11964_SH Apr 14
12536_SH Apr 14
13506_SH Apr 14

Thanks in advance for your help with this

Oz