Hello all,

This should be a fairly easy macro for you guru's...

I have a large set of invoice data by row -- Column A is a hyperlink that opens and downloads the specific invoice .pdf (to downloads folder), Column B is the "Save as" file name. I simply want to run a macro to open each link and save the file to a specified folder (e.g. C:\Desktop\Vendor Invoices) as the file name in the corresponding row and then continue onto the next row.

There are hundreds of thousands of rows of data spanning multiple years, so this macro must be automatic and require no user interface after beginning to run the macro. I only need to run it once to save these invoices.

All help is GREATLY appreciated!