Renaming 5000 Files using excel - Help

[Eccleshall]

Hi There,

I hope someone can help me,

I need to rename 5000 image files, I have looked around on the internet but cant find a way thats well explained,

I have created a file with the original filenames in column A in column B i have a "|" and in column C I have the New filename i would like and in column D i have them all combined, i was going to use Batch Rename Utility but i cant get it to work,

Could someone please advise me how to use in or another way


Thanks Much Apprichiated

 

[kpark91]

I think the batch file isn't working because of the character "|"

i would suggest you use "-" instead.

The characters not allowed in the filenames are
<>:"/\|?*

gotten from:
http://msdn.microsoft.com/en-us/library/aa365247(v=vs.85).aspx

 

[Eccleshall]

Sorry forgot to say, its the column D getting put into a text file so i think that the | just splits it, | is what the manual for the program says to use

Could a vb script search column A to find the match and then Rename it with column C?

Thanks

 

[Lionround]

I am pretty good with Batch Rename Utility. Use it all the time. Be glad to help that way if you like.

 

[Eccleshall]

Could you LionRound? That would be a great help, is how I've described above the correct way? I'm struggling on what to put where could you write me out a simple check list or something I could go through

Thank you very much if so

 

[Lionround]

Sure thing. Check your messages.