Search column & edit file names

[scrupul0us]

Sort of an interesting situation here... I'm reconciling an unfortunate deletion of about 200 image files from a clients webserver that all had unique generated ID's in front of them... luckily the DB wasn't altered so I have the filename with the unique ID in its entirety in an excel spread sheet...

I have most of the original images minus about 60 or so, all of which do not have the unique ID appended to them and I was hoping an quick and dirty macro could easily solve my problem

I have a column, column B (row 1 is a header row) that has all the image names with the unique ID

example:

DB stored name: 555684_10northmainstreet.JPG (this is the value in column B)
The unique ID is: 555684_
The file I have is: 10northmainstreet.JPG

The unique id is always a random number followed by an underscore

What I'm hoping someone can do for me is to write a little macro that parses C:\cplimages to check for the existence of the image file (i have both JPG and BMP) and if it finds it, append the UID to the front of the filename...

possibly worth noting, when i click on the cell with the filename there is a leading single quote visible in the formula bar that isn't visible in the cell data

any help is GREATLY appreciated

 

[scrupul0us]

looks like some GIF's in there too