basebalplayr33
New Member
- Joined
- Aug 14, 2013
- Messages
- 44
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:
<tbody>
</tbody>
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!
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:
Card | Pos | Ctry | Player Name | Live | To Par | Thru | Today | R1 | R2 | R3 | R4 | Total |
[Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] |
[Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] |
[Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] |
[Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] | [Record] |
<tbody>
</tbody>
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!
Last edited: