Automating Excel Table from Web Site

[basebalplayr33]

Hey all,

I am trying to pull a listing of the weekly PGA Tour leaderboard from a website that I will be able to populate and refresh each time I open the document. I tried simply going to Data > From Web > and pasting the URL and clicking ok. The URL that I am trying to use is http://www.cbssports.com/golf/leaderboard . I was able to pull the table into excel and it looks as follows:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Card[/TD]
[TD]Pos[/TD]
[TD]Ctry[/TD]
[TD]Player Name[/TD]
[TD]Live[/TD]
[TD]To Par[/TD]
[TD]Thru[/TD]
[TD]Today[/TD]
[TD]R1[/TD]
[TD]R2[/TD]
[TD]R3[/TD]
[TD]R4[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[/TR]
[TR]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[/TR]
[TR]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[/TR]
[TR]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[TD][Record][/TD]
[/TR]
</tbody>[/TABLE]

Each field is currently being populated with "[Record]" as opposed to the player name, their position, etc. Does anyone have any ideas on how I can fix this using my method or using a macro to pull the data? Below are three other websites that I have found with a leaderboard that refreshes for each week in case this site isn't in a usable format:

https://www.pgatour.com/leaderboard.html

https://www.pga.com/news/golf-leaderboard/pga-tour-leaderboard


http://www.golfchannel.com/tours/pga-tour

As always, thank you all in advance for any help you can provide me!

 

[mole999]

That page has so many scripts associated. I does a lot of analytics and tracing to see where its called from (right click > view page source). There are programmes that claim to be able to load web info but I couldn't recommend any as I don't use them