getting halftime results from betexplorer

labirynth

New Member
Joined
Apr 25, 2018
Messages
2
Hello everyone,
hope you are all doing fine :)

So I have this macro and I am able to get the entire rounds and Fulltime results from betexplorer.com .

I would also like to get the halftime results of every round too, but I still have no idea how to do it.
Could you please have a look? I searched the forum, john_w has done an amazing job with one macro but that macro takes also the odds of total goals and takes a lot more time than this macro here.

Thank you

Code:
Sub Results()

'location of your HTTP
Application.ScreenUpdating = False
URLVal1 = Range("http!A2")

Application.StatusBar = Sheets("http").Range("I2").Value & Sheets("http").Range("A2").Value
'include some instruction to clear the previous collected data from your download sheet
Shell "RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 8"

Sheets("ScrapeData").Activate
Cells.Select
    Selection.ClearContents

Sheets("ScrapeData").Activate

With Sheets("ScrapeData").QueryTables.Add(Connection:= _
"URL;" & URLVal1, Destination:=Range( _
"$A$2"))
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlOverwriteCells
.SaveData = True
.AdjustColumnWidth = False
.RefreshPeriod = 0
DATA_SELECTION:
'.WebSelectionType = xlEntirePage
.WebSelectionType = xlSpecifiedTables
.WebTables = "1"
DATA_FORMATTING:
'.WebFormatting = xlWebFormattingAll
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = False
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = True
.WebDisableRedirections = True
.Refresh BackgroundQuery:=False

End With

For Each qtb In ActiveSheet.QueryTables
qtb.Delete
Next
Do While ActiveWorkbook.Connections.count > 0

ActiveWorkbook.Connections.Item(ActiveWorkbook.Connections.count).Delete

Loop

End Sub
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Forum statistics

Threads
1,223,262
Messages
6,171,080
Members
452,377
Latest member
bradfordsam

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