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

doogis2003

New Member
Joined
Jun 2, 2020
Messages
16
Office Version
  1. 365
Platform
  1. Windows
Hello,

I tried using the Get Data > From Web feature to grab an exchange rate table from the following site: Rates Page

There isn't any table data in Table View but I can see it in Web View with the message "Table highlighting is disabled because the page uses Internet Explorer's Compatibility Mode. I'm realizing that the way the website generates this table means I can't use the Get Data > From Web method.

Is there a workaround to copy this table data using VBA or another method?

Thank you,

AC
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Welcome

You could use Power Query, see picture below:

pq1.PNG
 
Upvote 0
Worf,

Thank you for replying to my message.

I opened the Power Query Editor and selected "New Source" directing it to the same URL as before: Rates Page

I'm still not able to see the table from that page. What I get is pictured below. How were you able to work around this in your example above? Note I am able to retrieve table data from a different exchange rates page though.

Thank you,

AC

1591316423748.png
1591316757641.png
 
Upvote 0
Once accepting "document" as the source, I dug into the HTML & Table to try to find the data but was only able to get to the 6 table headings but couldn't find the data.
 
Upvote 0
try shortcut: Alt A PN O W
then paste url and ok

you should see this first
fw.png

so select this then hit edit to see this
data.png


example file:
 
Last edited:
Upvote 0
Sandy666,

Tried your suggestion but after pasting the URL, I don't see the line "Rates updated on M/DD/YY at <time>". I still only see "Document" Tried both http & https. Is there an Excel setting that could be causing this?
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,099
Members
452,301
Latest member
QualityAssurance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top