Hello everyone, I'm hoping there might be an Excel guru or two in our midst. :)
Yesterday, I found a neat little tool to create an Excel spreadsheet list of all the files in a directory (http://www.finrepinc.com/prod02.htm). In this instance, it produced a spreadsheet with over 3500 lines. Of the columns I am using, one has the filename, the other has the directory path. I set up the next column to concatenate the two columns, so that I have the full path. What I'd like now is to hyperlink each full path, so that if I want to compare two documents in the list, I only have to click on their links in the spreadsheet. I've searched Google, but so far, I've not found what I'm looking for. Any ideas? Thanks! Lisa G. ______________________________________________ Author Help files and create printed documentation with Doc-To-Help. New release adds Team Authoring Support, enhanced Web-based help technology and PDF output. Learn more at www.doctohelp.com/tcp. Interactive 3D Documentation Parts catalogs, animated instructions, and more. www.i3deverywhere.com _______________________________________________ Technical Communication Professionals Post a message to the list: email [EMAIL PROTECTED] Subscribe, unsubscribe, archives, account options, list info: http://techcommpros.com/mailman/listinfo/tcp_techcommpros.com Subscribe (email): send a blank message to [EMAIL PROTECTED] Unsubscribe (email): send a blank message to [EMAIL PROTECTED] Need help? Contact [EMAIL PROTECTED] Get the TCP whole experience! http://www.techcommpros.com
