I have 150 pictures of college students which where taking with a digital camera. The Digtal camera names the files in format DC128973.jpg. I have all the names of the students in excel spreadsheet in the order the pictures where taken. Is they a way of renaming the files with the names contained within the spreadsheet. I want the new file format to been James_Willams.jpg
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Rename a picture file with a name contained in excel spreadsheet
- Thread starter ricalpmar
- Start date
- Thread starter
- #3
You can search this site for "reading excel files" to get your answer on how to read the contents of the cells in an excel spreed sheet.
One thing that I hope you have is a cross reference in your excel spreed sheet. By this I mean you have the origional file name and the name that you want to rename the file to.
You then can use the Name function to rename all of your files.
Good Luck
- Status
Similar threads
- Question
