Unable to grab table using GetData>FromWeb; can see in web view only

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

doogis2003

New Member
Joined
Jun 2, 2020
Messages
16
Office Version
365
Platform
Windows
To elaborate on Power BI trial, I am in Canada. With VPN on, server through USA I can refresh data. I drop the VPN, refresh and data disappears. Either way, the VPN/region does not seem to have any impact on Excel which is where I need to pull the data to.

Do you think the region change effect on Power BI is purely coincidence or a symptom of the issue?
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,314
If there is any chance change region to, eg Mexico or Germany?
 

doogis2003

New Member
Joined
Jun 2, 2020
Messages
16
Office Version
365
Platform
Windows
Mexico is working similar to US; Germany is a no similar to Canada (for Power BI)

Still no effect on Excel
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,314
you've two options:
- owner of this site
- microsoft excel help
 

doogis2003

New Member
Joined
Jun 2, 2020
Messages
16
Office Version
365
Platform
Windows
Sandy666, thanks for all your help so far!

If anyone else has any ideas, would be appreciated!
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,314
You are welcome
 

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
3,967
This worked for me:

VBA Code:
Public d As ChromeDriver

Sub withC()
Dim tb As Object
Set d = New ChromeDriver
d.get "https://rates.currencywholesale.com/rates/rates.html"
Set tb = d.FindElementByXPath("//*[@id=""currency_table""]")
d.Wait 2000
tb.AsTable.ToExcel ThisWorkbook.Worksheets("Sheet1").[a1]
End Sub
 

doogis2003

New Member
Joined
Jun 2, 2020
Messages
16
Office Version
365
Platform
Windows
Thanks Worf, I'll give that a try. Do I have to install an extension for ChromeDriver?
 

Watch MrExcel Video

Forum statistics

Threads
1,099,006
Messages
5,465,962
Members
406,457
Latest member
Pinky Rose Jordan

This Week's Hot Topics

Top