Batch renaming of Solidworks files, using PDM Workgroup

Hi there,

Our company is in the process of implementing a new MRP system & as a consequence ALL of our existing product codes are having a complete overhaul and will be renamed to a more consistant type of coding.

This is a good idea and does need doing - however, in the last 3 years of having Solidworks we have generated about 3,500 files (parts/assemblies/drawings) that are now going to need renaming to the new product codes. They all sit in our 'vault' of the PDM Workgroup system. This is a mammoth task !!   

So I am wondering, has anyone else had to do a batch re-naming of files (using PDM Workgroup) - and have they found a way to automate this process somehow ?? 

We will have a spreadsheet with 2 columns, one for old part number and one for new part number. So I'm thinking somehow along the lines of a V-LOOKUP kind of approach.......  

I'm scratching my head here and trying to think of a way to avoid doing this manually !!!   Any suggestions would be appreciated  

SolidworksWorkgroup Pdm