Web query issue

sitewolf

Active Member
Joined
May 4, 2012
Messages
304
I've had this spread I've used for literally years to pull in PGA golf stats- originally created pre-2003 I think.
I've not changed it much, other than save it into new formats along the way, because...it works, so why.

It was working fine as recently as last Sunday, but for this week's tournament it's not. Usually the only VBA tweak I've needed is to occasionally adjust the web tables I'm picking up.

My spread is set to run thru a list of golfers, picking up stats from each's scorecards.

Example link:
https://www.cbssports.com/golf/players/scorecard/399343/2881657/2018/PGA

Currently VBA is set to grab tables 2 and 4, which has been what's been needed for quite awhile, at least all calendar year.
Suddenly there's no data there....and I've not found table numbers thus far that pull in data

Ideas? I'm on Office 365

Snippet from VBA:
For n = 1 To Actives
On Error Resume Next
Range("B2").Select
QueryAddress = ActiveCell
RemoveNames
Range("L8:AK102").ClearContents
CleanUp
With ActiveSheet.QueryTables.Add(Connection:=QueryAddress, Destination:=Range("M8"))
.Name = "LiveStats"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlOverwriteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = False
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingAll
.WebTables = "2,4"
.WebPreFormattedextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = True
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,633
Latest member
DougMo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top