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

You don't need a macro for this, as it can be done quite easily with the Windows Command Prompt. There are also many freeware file renaming utilities you can obtain for doing the same thing.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Macropod

Many thanks, managed to get it done using Powershell

Rgds
O