i have 1000 of images in my folder E:\XtremeImages\images
in my excel original names are listed in A range and B range has the new names
eg:
A range contains
01.17.jpg
01.17_01.jpg
01.17_02.jpg
01.17_03.jpg
01.17_04.jpg
01.17_05.jpg
01.17_06.jpg
B range contains
B1=a.jpg
B2=
B3=e.jpg
B4=
B5=j.jpg
B6=
i need to change
01.17.jpg as a.jpg
01.17_02.jpg as e.jpg
01.17_04.jpg as j.jpg
any one help with a macro for that
Hi anilg0001,
Try this:
Regards,
Please Login or Register to view this content.
Robert
Last edited by Trebor76; 10-21-2014 at 06:22 PM.
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Thanks Trebor
sorry for the deleyed reply
its work perfectly
thanks you very much
Last edited by anilg0001; 10-23-2014 at 05:56 AM.
You're welcome.
If you could please mark the thread as solved it would be appreciated.
Thanks,
Robert
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks