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

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,224,823
Messages
6,181,171
Members
453,021
Latest member
Justyna P

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