Adding Hyperlinks to Excel that point towards images contained in a folder

**dbarnett** · 10-24-2012, 10:37 AM

I have a problem that I'm sure has been covered before but I can't find the answer.

I have a folder of 550 .jpg images on a network drive that I want to create hyperlinks to in Excel (in a single column). It is straightforward to do these hyperlinks one at a time but very time consuming.

So what I want is for the macro/ code to open up and ask 'which folder of images would you link to hyperlink to' then give me the excel sheet with this column of links listed.

If anyone could help that would save me a lot of time

Many thanks

**6StringJazzer** · 10-24-2012, 01:26 PM

Welcome to the Forum!

This is a pretty specific request and I don't know if a solution to this has already been developed. Normally I wouldn't raise my hand to do it from scratch but I had some of this done in a similar solution so I modified it for you. [Build list of hyperlinks to image files.xlsm]

Note that I chose to use the HYPERLINK function instead of inserting actual hyperlinks. The latter can be done but for what you need the results would be the same.