Importing data into Excel from a website

[Bertie99]

Hi

I copy data from about 20 different website pages into an excel file on a daily basis.

I am trying to automate this, so I can just refresh the links on a daily basis, instead of copying the data into each of the 20 or so different pages.

The website is password protected, I am a registered user with login and password.

I am not having any luck in getting this set up, despite repeated attempts.

My process as is, is to click on Data/From Web/Basic URL

I then paste the URL horseracebase.com/shortcuts.php?shortcut=50

It then brings up a navigator screen and this is where I seem to be failing.

It doesn't display the data from the web page that I am hoping to see- this is when I am clicked on the 'Table view'.

When I click on the 'web view' it says 'Table highlighting is disabled because this page uses Internet Explorer's Compatability mode'.

Anyone have any suggestions for how I can progress this? I'm happy to provide more information/ data if needed.

Kind Regards.

MrExcel extract.png