asked on

rename in batch ,many photos in a dir , from a xls list column data ?

i have a dir "Photos_ID1" in desktop , with photos named all ready from a list of column ''B'' in sheet "Prod_Photos" also there is a photo called "No_photo_yet.jpg"

" A " " B " Dir "Photos_ID1" final result on dir
Su10000-M95-C413 156-0099 156-0099.jpg Su10000-M95-C413.jpg
Su10001-M520-C41 140-1829 140-1829.jpg Su10001-M520-C41.jpg
Su10002-M95-C413 156-0145 156-0145.jpg Su10002-M95-C413.jpg

1. i want to compare the "B" list with dir /photos and if i dont have photo with the selected value , i want in "B" column to replace the cell with value "No_photo_yet"

2nd ....i want to rename the photos in dir ,with the "A" column

Do this for 6000 values in "B" or "A"

many thanks , to everyone that helps.

ASKER CERTIFIED SOLUTION

Steve

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tonyantony

ASKER

i tested 1st macro , no need for the other, works fine many thanks , good job

Steve

Glad to help, I just did the second as it was what you asked for, but I thought leaving the original data alone was a cleaner result.

ATB
Steve.