I need to pull in a list of filenames that are stored on my sever into a spreadsheet.

[Freenorm]

I am trying to create a formula that will hyperlink to files on my server using a partial filename and wild cards to pick up the info I do not know. Can this be done with a formula?

[:) Sixthsense :)]

Refer the answer posted for your EARLIER THREAD ON ANOTHER FORUM OF THIS SITE
http://www.excelforum.com/excel-prog...readsheet.html

[Freenorm]

I will need this list to update when opening the workbook because the file names change frequently and I will be using a formula to change the returned names to hyperlinks.

[:) Sixthsense :)]

Add the below code in ON OPEN EVENT OF YOUR WORKBOOK

Please Login or Register  to view this content.