Hello All,

I found a few threads that give great examples of macros that create a list of hyperlinks to files in a folder.

Unfortunately for me I have a folder of about 2,000 files that will be on a USB stick The drive letter changes from PC to PC. So I need a macro that can create a list of hyperlink files that do not contain the drive letter, just the current path that the Excel file running the macro is in.

Here is the code for what works great but is not portable.
Please Login or Register  to view this content.
Thank You All.