Generating a list of Hyperlinks pointing to docs on a fileshare

In the attached document you will see a table that I want to use to analyse project impact on our department and generate out of the calculated value a list of necessary documents that must be used.
Also there is a button to refresh this listed documents cause the might change.

Any ideas how i can get this. Also you will find some formulas that i developed allready. So fee lfreee to use them in case they are good for you.

Any help is appreciated.

Thanks in advance
Dieter

Try what I posted at vbaexpress.

Probably i was not exact enough in my description. I dont want to find all docs in a share.

Based on the calculated value in my sample sheet (Value in C30) the list of documents will be different. That means when the value is on 4 you probably see 8 documents that you have to use for this project, therefore if the value is just 2 you see a list of 4 docs that are necessary.
The documents are in a fileshare example

X:\\templates\value-is-2\document1.doc (and upt to 4)
\value-is-4\document1.doc (and up to 8 documents)
These documenst should be seen as a linklist when you click on that command button.

I hope this makes it a bit clearer.

Thanks for your idea, i tried but it did not show up with what i wanted.

Greetings Dieter

The method that I posted gives you several options. You don't have to search subfolders.

Please Login or Register  to view this content.

It finds all files by the y="*" but you can filter for other file names like "*.doc" if that is what you wanted.

So, the last modification would be the path that you pass to the function. Not sure how C30's 0.83 would be part of path name though.

Since you are not checking subfolder paths, a simple Dir() Loop can be used to get your files. This may be the best route for you anyway. However, more example data would be needed for me to determine your needs a bit better.

e.g.
1. C30=4
2. Clicking the button does this.
a. Deletes all data on Sheet "Silo 1".
b. Puts hyperlinks to all files in "Silo 1"'s Column A1 and down from path: x:\templates\4\

As you can see, I don't know what you want specifically.