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

[doogis2003]

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

 

[Worf]

Welcome

You could use Power Query, see picture below:

 

[doogis2003]

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

 

[doogis2003]

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.

 

[doogis2003]

I managed to get as far as here:

 

[sandy666]

try shortcut: Alt A PN O W
then paste url and ok

you should see this first

so select this then hit edit to see this

example file:

s666-PQ-fromweb.xlsx

Microsoft Excel Workbook

1drv.ms

 

[doogis2003]

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?

 

[sandy666]

to be sure, are you trying this?

 

[doogis2003]

Yes, exactly that.

 

[doogis2003]

Sandy666, these are the steps I am trying: