Find Jobs
Hire Freelancers

Optimize/speed up excel VBA code to scrape data

$10-30 USD

Completed
Posted over 3 years ago

$10-30 USD

Paid on delivery
I have an excel VBA code that does this: 1. Goes to a specific website using selenium chromedriver and scrapes coordinates(latitude and longitude). 2. Pastes them into the excel sheet in the relevant row. It takes about 20 seconds or so to scrape one set of coordinates, I would like to make it faster to about 5 seconds. I'm looking for a VBA expert who can do this for me. Contact me if you think you can do this job and I will send you the code. Thanks!
Project ID: 27847750

About the project

15 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello. I have a single piece of code which would (i think) make the script faster. The code will disable selenium images so everything will load faster. But if you want real speed, i can rewrite your script. When you click on "1852" in your video, you send a request and in return you get all your coordinates. But in different coordinates system. Like " "x" : 5172410.5956246015, "y" : 2880772.461897317". I know how to catch those coordinates, and convert them to actual coordinates. But it should be written in Python not Excel. Also, it will cost more. But you'll get real speed. If you want to talk about either techniques, please message. Thanks.
$20 USD in 1 day
5.0 (82 reviews)
5.6
5.6
15 freelancers are bidding on average $25 USD for this job
User Avatar
Please check my reviews. VBA expert is here. As you can I am a professional Scraper with various kinds of experience including Amazon, eBay and so on. My own scraping way and libraries always lead me to success. Using Scrapy, Selenium, API, C#, Node.... When I promise something I never ever break that promise. Don't worry Professional and honorable man is here. Let's continue our conversation on a chat. Ruslan.
$30 USD in 1 day
5.0 (10 reviews)
5.2
5.2
User Avatar
Hi there, I can help you to reduce the processing time to 5-8 seconds to get the coordinates (lat and long). I am a Microsoft Certified Professional in excel and VBA as an Expert. Awaiting your response. Regards, Karthick G.
$30 USD in 2 days
5.0 (37 reviews)
5.1
5.1
User Avatar
Hello, i can make it much quicker with python. I can rewrite the code for you and the data will be saved as usual in excel. Best
$40 USD in 7 days
5.0 (23 reviews)
4.6
4.6
User Avatar
Hi, I can assist you in the best way & according to project requirement. I am an expert and professional in MS Excel & VBA. It includes extracting information from text files, websites, transferring info in to excel, User forms, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet, etc. I have also handled various Excel tasks. It includes the creation of formulas using arrays, Pivot table creation, Creation of graphs, filtering, removing duplicates, Data analysis etc. Delivery time: - 1 Day. You can see my profile before awarding me your project. “https://www.freelancer.com/u/yadavexpert53” Let's initiate quick chat and discuss together. I would be happy to answer any queries that you may have Thanks, MBY
$40 USD in 7 days
4.9 (30 reviews)
4.4
4.4
User Avatar
Hey! I would like to get this task done for you and I’m available to do it right now for you. I have understood your requirements and have the required knowledge for this
$25 USD in 3 days
5.0 (66 reviews)
4.4
4.4
User Avatar
Hi, manager! Nice to meet you. I hope you are well and staying safe without COVID-19 effect As checking your job description, I have noticed I'm a good fit for your project from my skills and experience. 1. My scraping works and experience I have 5 years of experience in web scraping and scraped so many many websites(around 1,000). Also, I have extracted the product data from shopping websites like Amazon, eBay, Aliexpress, Taobao and etc. 2. My preferred scraping methods I make my own scraping tools with python. In order to make a python scraping tool, I use several Python scraping frameworks like Scrapy, selenium, and so on. And I use parse libraries like BeautifulSoup, lxml, regular expression, and so on. What's more, I have enough experience in up-to-date scraping techniques like IP-rotation with crawlers or other proxies and anti-captchas, scraping dynamic web pages. 3. Time Availability I can start your project right now. I'm an individual web developer, so I can commit all of my time to your project until it is done completely. Feel free to arrange an interview for discussing your job in detail. Looking forward to hearing from you. Best regards.
$30 USD in 1 day
5.0 (12 reviews)
4.2
4.2
User Avatar
Hi... I am an expert in vba and I can do your work accurately. Please text me so that we can discuss about this further.
$20 USD in 1 day
5.0 (20 reviews)
3.7
3.7
User Avatar
Greetings, I think here you are looking for someone to optimize/speed up excel VBA code to scrape data. I understood your project description. I am an expert in Visual Basic, Excel, Web Scraping, Selenium Webdriver, Selenium and I am really interested in your project. I am really confident that, I can do this with 100% accuracy and ready to start now! But I want to know more about your project. So, can we discuss more? So, please take your time to discuss more on your project with me. Thank you.
$25 USD in 3 days
5.0 (5 reviews)
2.8
2.8
User Avatar
hii ! iam expert for this work .i can complete this work . within set target time frame .iam very honest and responsible parson.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hourly working in bit to 5 in every hours and project completed in 30 bit for 7 days condition apply
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir/mam , I have a lot of experience in typing and excel so kindly consider it and I'll complete your project within time without any errors.
$19 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
we can try scraping via xml or we can use python selenium or scrapy library. ill do it for free. Let me introduce myself, my name is lakhan and i have 6years of experience in vba currently i am working on scrapy and selenium project in my company
$10 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SAUDI ARABIA
Riyadh, Saudi Arabia
5.0
4
Payment method verified
Member since Oct 12, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.