Find Jobs
Hire Freelancers

Vba Script fix

€8-30 EUR

Terminado
Publicado hace más de 1 año

€8-30 EUR

Pagado a la entrega
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 del proyecto: 35065193

Información sobre el proyecto

10 propuestas
Proyecto remoto
Activo hace 2 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
€0 EUR en 7 días
5,0 (2 comentarios)
3,1
3,1
10 freelancers están ofertando un promedio de €26 EUR por este trabajo
Avatar del usuario
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 en 1 día
5,0 (171 comentarios)
6,8
6,8
Avatar del usuario
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 en 1 día
4,9 (46 comentarios)
5,5
5,5
Avatar del usuario
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 en 7 días
5,0 (7 comentarios)
4,8
4,8
Avatar del usuario
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 en 1 día
5,0 (6 comentarios)
3,1
3,1
Avatar del usuario
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 en 2 días
5,0 (2 comentarios)
0,9
0,9
Avatar del usuario
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 en 1 día
0,0 (1 comentario)
0,0
0,0
Avatar del usuario
Estimado...Tengo experiencia en VBA, puedo ayudarlo en este proyecto. Estoy disponible. Saludos Roberto
€10 EUR en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de ITALY
Villanova Mondovì, Italy
4,9
223
Forma de pago verificada
Miembro desde jun 25, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.