Need VBA code to open URLs from Excel in google Chrome when web page open save as pdf in a specific folder

[Sandri60]

I've found other threads similar to what I need to achieve but I've been unsuccessful in replicating to fit my needs. I'm very new to VBA so if someone can assist that would be great!

I need a VBA code in Excel, the goal is to open URLs in Excel, “print as PDF” and then save the file in a specific folder.

Here are the steps:

1. Open the URLs from Excel cell A1 in Chrome browser.
2. There will be a login to a portal with a username and password, the URLs have the an API included already but I suspect the login still be required.
3. Print as PDF.
4. Every URL will have the exact name to be used when saving/printing on cell B. Copy & paste that name.
5. Save the file into a specific folder.
6. Repeat the same steps for all URLs in the file.

Please keep in mind that there are around 6,000 URLs on this file but the VBA code will need to be dynamic in order to be used in other files.

 

[Automatrix]

Have you looked at using Power Automate instead?

 

[Sandri60]

Thanks so much for you reply!

That is very interesting, that was the tool I was exploring at first then I talked to one of my colleagues and he suggested to try with VBA instead.
So do you think it would be possible to do the loops thru all the URLs in the Excel file?

 

[Automatrix]

Certainly. I have only worked with the desktop version myself, but I think that the online version can do the trick as well. I'm sure it has a much easier learning curve than VBA.

What you are trying to do is known as Web Scraping, to get your googling started

 

[Sandri60]

Would you be available to assist with this? I'm willing to learn but I need to get it done ASAP.