GET VALUE FROM HREF IN WEB PAGE

[sal21]

Based this link

https://www.gardainformatica.it/database-comuni-italiani#scarica

how to get only the link value in href item:

<a href="/gi_db_comuni/gi_db_comuni-2023-06-30-3bfd3.zip" class="btn btn-primary btn-lg">Scarica il database dei comuni italiani</a>

or get simly the date of: Ultima data di aggiornamento dei dati: 30/06/2023

in my case is:

https://www.gardainformatica.it/gi_db_comuni/gi_db_comuni-2023-06-30-3bfd3.zip

https://files.engineering.com/getfi...ae32-48b5-9b71-5fd807e566c5&file=Immagine.jpg

 

[strongm]

Seriously? We've demonstrated pulling data from a webpage many times to you.

The following needs a reference to the MS HTML Object Library to be set. And that's all the explanation I have time for.

[COLOR=blue]Public Sub Sal21()

Dim myHTMLDoc As New HTMLDocument

With CreateObject("MSXML2.XMLHTTP")
    .Open "GET", "[URL unfurl="true"]https://www.gardainformatica.it/database-comuni-italiani#scarica",[/URL] False
    .send
    myHTMLDoc.body.innerHTML = .responseText
End With

MsgBox myHTMLDoc.getElementsByClassName("btn btn-primary btn-lg")(9).nameProp

End Sub[/color]

 

[sal21]

tks as usual strongm!

and for:

or get simly the date of: Ultima data di aggiornamento dei dati: 30/06/2023

 

[strongm]

[COLOR=blue]Public Sub Sal21()

Dim myHTMLDoc As New HTMLDocument

With CreateObject("MSXML2.XMLHTTP")
    .Open "GET", "[URL unfurl="true"]https://www.gardainformatica.it/database-comuni-italiani#scarica",[/URL] False
    .send
    myHTMLDoc.body.innerHTML = .responseText
End With

MsgBox myHTMLDoc.querySelector("STRONG").innerText
MsgBox myHTMLDoc.getElementsByClassName("btn btn-primary btn-lg")(9).nameProp

End Sub[/color]