Picture from Excel to a file

[Kristensen11]

Hi Guys,

I'm new in this forum and VBA.

I need a code that can export a picture from excel into a folder on my desktop. I would like to insert the link as a range and the the name as well (maybe using offset or something similar) - Can anyone help with this (don't have to incl. the range)?

Thanks in advance !

 

[davesexcel]

Hello,
Where is this picture coming from?

 

[Kristensen11]

Hello,

It has been imported to excel via a URL (so from the internet) - but it is already imported into excel.

 

[davesexcel]

I do know that if you save the workbooks as a web page, the pictures will be saved in a folder.

As a practice, create a test folder. Save the workbook as a webpage into that folder, look in the folder and there should be a folder with the pictures from the workbook in there.