Create hyperlinks to files in folder

[JorgenKjer]

Hi

Can anyone help with a VBA code that makes a Hyperlink to cells?

This Workbook is a staff list where in column "E" it is possible to use a Hyperlink next to each person to see a photo

The path to the file is e.g.
C: \Users \ Division \ Staff \ 38543_Benny_Mcgee \ 38543_Benny_Mcgee_Photo.JPG

The path shown is
C: \ Users\ Division \ Staff \
+ "C2" + _ (underscore) + "A2" (underscore spaces in name) + \ + "C2" + _ (underscore) + "A2" (underscore between spaces in name) + _ (underscore) "Photo.JPD"

This example should be linked to "E2"

I hopethis makes sense

Regards

Jorgen

https://www.dropbox.com/sh/t3lr38mn75q2epo/AAAAurPfLOAjp1cEu0CQXL-pa?dl=0

 

[MUKESHY12390]

why VBA ?

simple Hyperlink formula can do job.

 

[MUKESHY12390]

I have attached file here https://www.dropbox.com/s/mtbsf8f68up54n7/Hyperlink.xlsm?dl=0

 

[JorgenKjer]

Hello MUKESHY12390

I have tried formulas, but I have a VBA code which sort the employees out into different sheets by departments and I have not succeeded in getting the formula copied so that the Hyperlink works on the departments sheets that the VBA code sort the employees into

Therefore,I thought it might be possible to create a code that will take that into account

Regards
Jørgen