Rename pictures and export them into JPG files

[gameboybin]

Hi everyone, i have this excel files that contains a lot of pictures and names of the people in the picture.

Can anyone help me create a macro or something to Rename those pictures into names of Column A and extract those pictures with that name???

Many Thanks!

 

[NdNoviceHlp]

Hi *gameboybin and Welcome to the Board! See the code at this link...

Save Images to Folder

Hello Everyone ! I have few excel with heavy database in which there is one column of images and one column with its model number. Is there any guide to save all images in bulk with it model # describe in other column. ( Many times there are merge cells also ) Any help will be a great time...

www.mrexcel.com

Change this line of code and it should work.....

Call CreateJPG(sh.Name, CStr(.Range(sh.TopLeftCell.Address).Offset(, -2)), sh)

HTH. Dave
Note: You will need to adjust the folder loacation code in the CreateJPEG sub and ensure that the folder exists
FolderLoc = "C:\testfolder\" ....... change this line of code to suit