Folder has X amount of jpeg files. How to automate creating links for those X amount of fi

I have a folder where I have between 45 and 90 photos saved. How can excel automatically create a hyperlink for every one of those photos in a different cell?

Something like this would give you hyperlinks in column A. You would need to change the folderpath as appropriate

Please Login or Register  to view this content.

Yudlugar, thank you so much!!!! This is EXACTLY what I'm looking for.

Qiuck minor question now... how do I rename the links so that the only wording that's on the link is the filename itself, instead of having the entire path show up as the link?

Thanks for the hint.

It was actually TextToDisplay:=fil.Name

Another quick question...

Since I create many folders with these pictures, is there a way where I can grab the file path from the worksheet cell instead of typing out the full path?

I have excel create the paths of where the photos lie. Now if I can somehow just incorporate that cell as "the path" instead of writing out the full path, that would be awesome.

Originally Posted by AndyLitch

If you create a list of folderpaths on a hidden worksheet You can iterate through them changing the folder with each iteration ..

instead of

Please Login or Register  to view this content.

You would have a line like :

Please Login or Register  to view this content.

Just one point about hyperlinks though -> They increase your workbook size exponentially..

Is there a way where I can assign the .getfolder be what's inside a specific cell instead of a Range of cells?

Originally Posted by JPWRana

Thanks for the hint.

It was actually TextToDisplay:=fil.Name

I have been using this for a while now, but the file extension keeps on popping up on the link name.

How do I create the links in a way that the link name will remove the file path?

For example...

Currently...
112255E id.jpg
3352354 est.jpg
345X(1).avi

How I want the link to show it as...
112255E id
3352354 est
345X(1)

Please Login or Register  to view this content.

It worked! Flawlessly too!

Now I wish I didn't have to go in the macro and manually change the folder path every time for each different project... but that's a different problem for a different forum thread I suppose.