Hi
I'm trying to import data regarding AWS pricing for London region from [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=000000]#000000[/URL] ]ec2instances.info website using VBA, but I always get data as if it was Northern Virginia region.
[/COLOR]I tried the following:
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000 ; background-color: #ffffff}span.s1 {color: #011993}</style> Worksheets("London").Activate
With ActiveSheet.QueryTables.Add(Connection:="url;https://ec2instances.info/?region=eu-west-2", Destination:=Range("d4"))
.Refresh BackgroundQuery:=False
.SaveData = True
End With
Please advise
Thanks,
Ran
I'm trying to import data regarding AWS pricing for London region from [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=000000]#000000[/URL] ]ec2instances.info website using VBA, but I always get data as if it was Northern Virginia region.
[/COLOR]I tried the following:
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000 ; background-color: #ffffff}span.s1 {color: #011993}</style> Worksheets("London").Activate
With ActiveSheet.QueryTables.Add(Connection:="url;https://ec2instances.info/?region=eu-west-2", Destination:=Range("d4"))
.Refresh BackgroundQuery:=False
.SaveData = True
End With
Please advise
Thanks,
Ran