Hello every one.
As the tittle says, I need a macro to open a link and save the loaded page as PDF using the name of the ID.
Basically, I have an Excel Workbook and it has a list of ID's (see "Sheet1" of the book find here: h t t p s :/ / 1drv.ms / u / s!AtNNX9wOipPOgzrosh7LMNILDGJ7?e=1TaExr)
One link + the ID let me open the web page that I need to save as PDF, for example: h t t p s: / / cdn.c.sat.gob.gt / rtu / constancia-rtu-portal?nit=21162484
Once the webpage is loaded, at the end there is a blue button called "IMPRIMIR REPORTE", it lets to save the page as PDF.
I got stucked on the vba code (see the Excel file) :/
Any help woud be much appreciate.
Thanks in advance.
P.S.: In the attached there are three example Is, the second one will return an error when try to check the info because the ID doesn't exist, this is only for test purposes. And finally, If possible that type of cases should be skipped.
Edit: I'm so sorry, I'm not allowed to post links, thats why you see the links in that way.
Bookmarks