To print PDF generated from an URL. Where URL is listed in Column A and name is stored in Column B and saved directory should be in D folder!

[tcimran]

Hy Excel Experts,

Is it possible to automate print and save using macros, like I have a list of URLs in Column A and a list of its file name to be saved in Column B, I want to go to each URL and save the pdf in it to a specific directory.
Hope it's possible because there are 100+ pdfs every month.

Thanks