I have used a macro in Excel 2003 that gathers all the file names in a directory, posts them to a worksheet, and coverts the list to hyperlinks. It uses shell32.dll and the exact code I can find in other posts on this forum.
It does not work in Excel 2007. I have changed my security settings...