I have an excel workbook with hyperlinked cells that point to .pdf files located in various folders on my company network. I would like to be able to create a macro that will allow me to select a range of cells (containing hyperlinks) and save copies of the associated .pdf files to the current folder in which the excel workbook resides. Any help would be greatly appreciated!!!