Auto hyperlink to files from list

Good morning folk

I have the code below to create a list of files in a folder on a sheet,,,,, is there a way to automatically have the file names hyperlinked to the files

Many thanks

JT

Please Login or Register  to view this content.

See if this is something you can work with:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Ron

many thanks for your help..... with one exception the code is doing as it should..... it is producing the list and creating a hyperlink from each file name..... however it is hyperlinking to the folder where the sheet containing the code and list is kept,,, not the folder where the files are stored........

I've been trying to adjust and figure it our myself,, but I'm not having any luck

JT

Please Login or Register  to view this content.

The code I posted uses the exact contents of the referenced cell to create a hyperlink.

Do you have an entry in the Hyperlink Base settings?

Please Login or Register  to view this content.