create hyperlink to folder or file

I have been well helped a few times by you, I have a question that unfortunately I am not able to solve.
I have made a tool with which I can easily add hyperlinks of files in an cell in a Excel sheet. By clicking on commandbutton1 I browse to the file select this, the url will be in texbox 1, after which I will save it as a hyperlink in the excel document.
Currently I am looking for a way to create a hyperlink to a folder. I would like to select a file or folder location and make it a hyperlink.

Below is the code i'm currently using, can anyone please help me?

Please Login or Register  to view this content.

Thank you for your fast repaly!
unfortunately this is not what I am looking for, with this code all files are automatically listed and hyperlinked in the dirctory.

what i'm looking for is a way how i can select and hyperlink a file or file folder

I know, that's why I put a note that you need to "play around" with the code .

Anyway:

Please Login or Register  to view this content.

I'm sorry for mis understanding, I was a bit socket because the server is overloaded with data and it takes a time before the system ends te creating all hyperlinks but it's finedhed, I go play with your code.