I have an Excel Spreadsheet that I export assembly Boms into and combines Filename & Folder Name & ".slddrw" to compose a hyperlink of the parts respective drawing to run prints.

I've used "Batch Save As Pdf" macro for batching but to do so i have to put copies of all the drawings into the same folder before hand. With parts that are located in different folders this creates meaningless work.

Has anyone found or written a marco that will batch save as pdf from an excel list of hyperlinks into a determind folder? This would allow me to make a set of prints from drawings that are scattered through-out multiple directories.