Get value from table html page

[sal21]

Based:

Comuni Italiani 2021

Per realizzare il progetto InformaCOVID di opendatasicilia è nata l’esigenza di avere una mappa/elenco di tutti i Comuni Italiani del 2021con tutti i dati principali che identificano ogni sig…

coseerobe.gbvitrano.it

how to gett all value from all column, in:

Esempio di tabella dati​

 

[Kerryx]

Use power query and link to the data source in this case

https://docs.google.com/spreadsheet...279888&single=true&widget=false&headers=false

let
Source = Web.Page(Web.Contents("https://docs.google.com/spreadsheet...279888&single=true&widget=false&headers=false")),
Data0 = Source{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data0,{{"Column1", type text}, {"Column2", Int64.Type}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}, {"Column13", type text}, {"Column14", type text}, {"Column15", type text}, {"Column16", type text}, {"Column17", type text}})
in
#"Changed Type"

 

[sal21]

tks

Use power query and link to the data source in this case

https://docs.google.com/spreadsheet...279888&single=true&widget=false&headers=false

let
Source = Web.Page(Web.Contents("https://docs.google.com/spreadsheet...279888&single=true&widget=false&headers=false")),
Data0 = Source{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data0,{{"Column1", type text}, {"Column2", Int64.Type}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}, {"Column13", type text}, {"Column14", type text}, {"Column15", type text}, {"Column16", type text}, {"Column17", type text}})
in
#"Changed Type"

, bro.
buty i need in vba, possible? Or i can call the power query via code via vba?