doogis2003
New Member
- Joined
- Jun 2, 2020
- Messages
- 16
- Office Version
- 365
- Platform
- 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
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