Extract and save pictures from excel sheet, assign file name shown in one column

Hello everyone,
The sheet I'm working on contains a lot of rows with pictures.
I want to save all the pictures in one folder, but with the name = the name shown in column A "Name"

hopefully I can get some directions/ tips

Hi, welcome to the forum.
I would suggest you take a look here, https://www.thespreadsheetguru.com/b...ure-file-excel it explains the idea and has samples.
The rest is up to your inventiveness an imagination to tweak it to your own needs, If you still get stuck ... holler
I'll take a look at your file but this is good VBA training so you don't have to always depend on others

I have a sample somewhere with a similar question, you can search for it on the forum for post I worked on, it's from about 2 years back but I'm sure there are more

I found the code, will try and complete it this weekend
Do you want to select the folder where to save the pictures?

Just in case you're still interested

Loos like OP's not interested anymore, the last login was the time the post was created

Hoi Hans.
It's weekend. Might be away from the computer.
Groetjes

BTW, ended up with a slightly shorter way.

Please Login or Register  to view this content.