Find Jobs
Hire Freelancers

I would like to hire an Excel VBA Developer

€8-30 EUR

Completato
Pubblicato più di 6 anni fa

€8-30 EUR

Pagato al completamento
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.
Rif. progetto: 15428456

Info sul progetto

3 proposte
Progetto a distanza
Attivo 6 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
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
Avatar dell'utente
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
€55 EUR in 2 giorni
4,9 (94 valutazioni)
6,1
6,1

Info sul cliente

Bandiera: NORWAY
Oslo, Norway
5,0
7
Metodo di pagamento verificato
Membro dal ott 18, 2017

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.