Hi! I have a excel spreadsheet which has 1000+ of hyperlinks in column B. When I click on each hyperlink, it opens in Internet explorer as a PDF. I have to save each individual file every time by a name in column C. Can somebody help me create a macro or VBA that'll automate this process?
Thanks!
Bookmarks