Lengkap

I would like to hire an Excel VBA Developer

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

[url removed, login to view] = True

[url removed, login to view] "[url removed, login to view]"

Do While [url removed, login to view] <> READYSTATE_COMPLETE

DoEvents

Loop

Ir = Range("A6536").End(xlUp).Row

For i = 2 To Ir

teams = Range("B" & i).Value

[url removed, login to view] teams & "matches/"

Do While [url removed, login to view] <> READYSTATE_COMPLETE

DoEvents

Loop

Set doc = [url removed, login to view]

For Each element In [url removed, login to view]("matches ")

Range("C" & i).Value = [url removed, login to view]

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.

Kemahiran: Excel, Excel VBA, Visual Basic

Lihat lagi: i am web designer and developer so how can i contact australian customer for web design, hire excel dashboard developer, hire an indian developer to do your work, vba developer roles and responsibilities, vba freelance hourly rate, vba programmer salary, freelance vba programmer, vba developer interview questions, vba programmer jobs, what is a vba developer, vba programmer job description, freelance excel vba developer, excel vba developer rexburg, excel vba developer jobs in dubai, excel vba developer job, excel vba developer hourly rate the netherlands, excel vba developer freelancers london, excel vba developer, hire excel vba programmer, excel vba developer skills

Tentang Majikan:
( 2 ulasan ) Oslo, Norway

ID Projek: #15428456

Dianugerahkan kepada:

The24CarrotsInc

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 an Lagi

€30 EUR dalam sehari
(52 Ulasan)
5.2

4 pekerja bebas membida secara purata €34 untuk pekerjaan ini

shafaqat11

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 ex Lagi

€55 EUR dalam 2 hari
(78 Ulasan)
5.4
€29 EUR dalam sehari
(5 Ulasan)
3.3
mfrahat

Hello I am highly interested to do your project . I am able to refresh this with your full satisfaction . I am confident about the work . Relevant Skills and Experience Excel, Excel VBA, Visual Basic Proposed Milesto Lagi

€23 EUR dalam sehari
(0 Ulasan)
0.0