Thank you so much for your help, gmayor! This is a game changer for me. This perfectly saves the hyperlink file to the folder on my desktop. There is one alteration I'm researching regarding the strFname.


How can you have reserved characters in the filenames?
I didn't explain this, sorry. These files are coming from a program we use. The files are technically saved with the 7 character alpha numeric string at the end of the hyperlink, the strSource in your macro. The files are linked within a database which allows us to assign them a "Reference Name" and other useful information about the files such as categories, dates, author, etc. It's those Reference Names that are eligible to contain the reserved characters.

File 1 Name Here= File://h:\lib\docs\LIAB\1234\2153265\MONKEY\2QR8323.DOC

This macro that you've created; thank you again btw, is currently saving the files with their "actual" file name: the 7 characters at the end of the hyperlink, "2QR8323". I would like to change that to the text at the beginning of the line and stopping before the equals sign: "File 1 Name Here".

I was looking at the code and I was wondering if the strFname String could be altered to refer to the "Reference Name" preceding the hyperlink rather than the "Actual" file name itself. I'm currently looking into how to begin the string at the beginning of the line containing the strSource hyperlink. Do you think that's possible?