Copy hyperlink contents (photos) to a new folder

[Agrocolo]

Hi everybody!

I have a problem in my job that is driving me mad! The point is that I got a huge list of hyperlinks in Excel and I need to copy the contents (images with .jpg format) and paste them in a new folder. It is important to say that I need to copy only a certain selection of the full list of hyperlinks, and I was wondering if there is someone who knows some kind of Macro (or anything else) suitable for this process. Thanks a lot and hope your answers!!

[Norie]

You should be able to get the paths of the hyperlinks and then use them with VBA to copy the files to another directory.

Where are the hyperlinks located in the workbook, what 'selection' of the hyperlinks/files do you want to copy and where do you want to copy them to?

[Agrocolo]

Thanks for your reply!!!

Yes I got the paths of the hyperlinks in a row. The images are located in a local folder (C:\Users\gis\Desktop\Images). The selection changes depending on the day because all images are referred to a different areas of environmental conservation, so sometimes I need to select 5 images and sometimes I have to select 50. I want to paste the selection in a new local folder (for example C:\Users\gis\Desktop\New_Folder). Is it possible?

Thanks again