So im trying to web scrape some soccer teams results that i've chosen. The first method was to:
Web scrape everything with vba. I used soccerway as my database, and stored the hyperlinks for each team in my excel sheet. The problem is that when the code is finished, all my data is unfiltered and in the same column for each team. For my data, i need each result to be in each column for every team. Im considering using getElementsByTagName. Heres my code that didnt't work:
Sub DownloadResults()
Dim ie As New InternetExplorer
Dim doc As HTMLDocument
Dim teams As String
Dim Ir As Integer
Dim i As Integer
Dim output As Variant
[login to view URL] = True
[login to view URL] "[login to view URL]"
Do While [login to view URL] <> READYSTATE_COMPLETE
DoEvents
Loop
Ir = Range("A6536").End(xlUp).Row
For i = 2 To Ir
teams = Range("B" & i).Value
[login to view URL] teams & "matches/"
Do While [login to view URL] <> READYSTATE_COMPLETE
DoEvents
Loop
Set doc = [login to view URL]
For Each element In [login to view URL]("matches ")
Range("C" & i).Value = [login to view URL]
Next element
Next i
End Sub
The second option is using querytables for downloading all my teams results into one database that can uptdate automatically. File under is all the hyperlinks you need.
Greetings for the day!!
We have experience working on this subject.
We ensure 100% QUALITY with ON-TIME Deliveries.
Please allow us to take this opportunity.
Thanks & Regards,
Team@The24CarrotsInc
Relevant Skills and Experience
VBA/EXCEL
Proposed Milestones
€30 EUR - 100% Satisfaction Of Deliverable
€30 EUR in 1 giorno
4,9 (72 valutazioni)
5,9
5,9
3 freelance hanno fatto un'offerta media di €38 EUR
Greetings sir, I am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement.
Relevant Skills and Experience
I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project.
Proposed Milestones
€55 EUR - Payment once project is complete