Find Jobs
Hire Freelancers

Vba Script fix

€8-30 EUR

Finalizat
Data postării: peste 1 an în urmă

€8-30 EUR

Plata la predare
Hello, I'm using a Vba script in order to scap data, but it doesnt' working more. I need to fix This is the script Sub pro1() Dim m As Integer 'If [login to view URL](Now()) = 8 And [login to view URL](Now()) = 9 And [login to view URL](Now()) = 2022 Then Dim element As IHTMLElement Dim elements As IHTMLElementCollection Dim IE As Object Dim html As HTMLDocument Set IE = CreateObject("[login to view URL]") 'If you want to see the internet explorer window you should type down as True otherwise False [login to view URL] = True For m = 2 To [login to view URL]("A" & [login to view URL]).End(xlUp).Row If [login to view URL]("B" & m) = "" Then GoTo lab2: Url = "[login to view URL]" & [login to view URL]("B" & m) & "&__mk_it_IT=%C3%85M%C3%85%C5%BD%C3%95%C3%91&crid=2J09C1LHL9BH2&sprefix=" & [login to view URL]("B" & m) & "%2Caps%2C184&ref=nb_sb_noss" [login to view URL] Url 'Wait until IE has loaded the web page Do While [login to view URL] <> READYSTATE_COMPLETE [login to view URL] = " Loading Web page … " DoEvents Loop [login to view URL] (Now() + TimeValue("00:00:02")) Set html = [login to view URL] On Error Resume Next [login to view URL]("sp-cc-accept").Click On Error GoTo 0 Set elements = [login to view URL]("sg-col-inner") 'Here is the className "priceblock_ourpirce" I found it in InspectElement but its not getting any data. I am not able to find the 'correct ClassName for Price and Name of Product from InspectElemnt. As I am not a web developer. Dim count As Long Dim erow As Long If InStr([login to view URL]("a-row")(0).innerText, "Nessun risultato per ") > 0 Then [login to view URL]("C" & m) = [login to view URL]("a-row")(0).innerText [login to view URL]("D" & m) = [login to view URL]("a-row")(0).innerText [login to view URL]("E" & m) = [login to view URL]("a-row")(0).innerText [login to view URL]("F" & m) = [login to view URL]("a-row")(0).innerText GoTo lab2: Else If [login to view URL] > 0 Then count = Split(elements(0).innerText, " ")(0) Else End If End If If count >= 1 Then j = False Set ele = [login to view URL]("rush-component s-latency-cf-section") For Each e In ele For Each i In [login to view URL]("span") If InStr([login to view URL], "RISULTATI") > 0 Then j = True k = 1 GoTo lab159: End If If j = True And k = 2 Then [login to view URL] j = False k = 1 GoTo lab1: End If If k = 1 Then k = 2 End If lab159: Next i Next e Else End If lab1: [login to view URL] (Now() + TimeValue("00:00:02")) On Error Resume Next ratings = [login to view URL]([login to view URL]("acrCustomerReviewText").innerText, " ")(0) Price = [login to view URL]("a-offscreen")(0).innerText For Each i In [login to view URL]("productDetails_detailBullets_sections1").[login to view URL]("tr") If InStr([login to view URL], "ASIN") > 0 Then Asin = Right([login to view URL]([login to view URL], "ASIN")(1), 11) GoTo lab195: End If Next i lab195: [login to view URL]("C" & m) = ratings [login to view URL]("D" & m) = Price [login to view URL]("E" & m) = link [login to view URL]("F" & m) = Asin ratings = "" Price = "" link = "" Asin = "" lab2: Next m MsgBox "Fetching done." End Sub
ID-ul proiectului: 35065193

Despre proiect

10 propuneri
Proiect la distanță
Activ: 2 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
€0 EUR în 7 zile
5,0 (2 recenzii)
3,1
3,1
10 freelanceri plasează o ofertă medie de €26 EUR pentru proiect
Avatarul utilizatorului
Hello! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Excel and vba, of course, familiar. Regards, Vladimir
€30 EUR în 1 zi
5,0 (171 recenzii)
6,8
6,8
Avatarul utilizatorului
Sir, I am EXCEL VBA, EXCEL MACROS, ALL FORMULAS, TEMPLATE, REPORTS, Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than 4 years of experience from the worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working here from the last 1.5 year and I have 224+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar
€35 EUR în 1 zi
4,9 (46 recenzii)
5,5
5,5
Avatarul utilizatorului
I have seen your code and can fix it in an hour please get in touch over chat for further details looking forward
€30 EUR în 7 zile
5,0 (7 recenzii)
4,8
4,8
Avatarul utilizatorului
Hello, sir. I have read your requirement and I noticed that I am appropriate to this project. I have over 8 years of experience in automation of Excel and Access documents by VBA. I wrote a lot of programs and got good reviews. I promise I can finish your project in time with high quality. Hope you kind contact. Best regards!
€20 EUR în 1 zi
5,0 (6 recenzii)
3,1
3,1
Avatarul utilizatorului
Hi there, # I have 8+ years of experience in VBA and RPA. I could use Excel VBA or UiPath bot to complete the task on time with dynamic coding and bug free. # Will support a month post project completion. # Could start the project immediately, once confirmed on our discussion. # Will keep your data safe and secure. # Will keep you posted on the stages. # I won't disappoint you as I have very strong knowledge and skills on RPA and I have done many projects on VBA and UiPath. # Please ping or call me to have a discussion.
€19 EUR în 2 zile
5,0 (2 recenzii)
0,9
0,9
Avatarul utilizatorului
Hi, Dear Employer, I am Al.A. I am a Ph.D. backgrounder and professional data scraper. I will provide you high-quality Excel file. I have worked on similar projects of excel/Visual Basic Web Scraping Excel VBA Data Scraping CSV and can deliver professional excel to tight deadlines. You can see an example of one of those projects in my portfolio:https://www.freelancer.com/u/alamineee. Please feel free to send me a message for a chat to discuss your requirements. Gratefulness, Al. A
€20 EUR în 1 zi
0,0 (1 recenzie)
0,0
0,0
Avatarul utilizatorului
Estimado...Tengo experiencia en VBA, puedo ayudarlo en este proyecto. Estoy disponible. Saludos Roberto
€10 EUR în 7 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Hi, Greetings and hoping you are doing well, i welcome you to my profile where quality and client satisfaction is the Priority. I am Expert Joseph and i hope to cooperate with you on your project . CERTIFIED EXPERT IN LISTED PROJECT SKILLS & REQUIREMENTS, After KEENLY reading your description and being in possession of all CLEARLY STATED REQUIRED SKILLS (Web Scraping, Data Scraping, Visual Basic and Excel VBA) as this is my area of PROFESSIONAL SPECIALISATION having the above QUALIFICATIONS, i hereby humbly request you to consider my bid for QUALITY and PROFESSIONAL work. ###// No timeline & Quality Excuses// Unlimited Revisions// 100% SATISFACTION GUARANTEED### Message Me We Discuss More About The Project. incase the project is deleted please hire me directly using the following link; https://www.freelancer.com/u/josephwriter1996 THANK-YOU & WELCOME.
€30 EUR în 1 zi
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
I am having 22 years of exp in VBA, PB, Oracle, RPA etc. I will be able to complete the job quickly with required quality.
€25 EUR în 7 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul ITALY
Villanova Mondovì, Italy
4,9
223
Metoda de plată a fost confirmată
Membru din iun. 25, 2014

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.