Terminé

Optimize/speed up excel VBA code to scrape data

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!

Compétences : Excel, Visual Basic, Web Scraping, Selenium Webdriver, Selenium

en voir plus : excel vba access sheet data, excel vba code optmization, excel vba code optimis, how to improve excel performance, optimize vba code, how to speed up excel solver, speed up vba, vba code to open excel file faster, improve excel performance with large files, vba open workbook faster, macro to clean up data in excel, excel vba return xml data type, excel vba code log websites, outlook 2003 vba code extract data, excel vba update imported data, excel vba code data web page, excel vba code pull internet data, vba code update data excel, excel vba code download historical data yahoo, excel vba code read serial data

Concernant l'employeur :
( 1 commentaire ) Riyadh, Saudi Arabia

Nº du projet : #27847750

Décerné à:

ilkecokay

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 c Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(62 Commentaires)
5.4

16 freelances font une offre moyenne de 26 $ pour ce travail

(100 Commentaires)
5.8
dhanrajkarthick

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, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(32 Commentaires)
4.9
yes0

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(66 Commentaires)
4.4
science64

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(20 Commentaires)
4.4
rkurilenko007

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
3.9
yadavexpert53

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, U Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(21 Commentaires)
3.7
apriyanka0222

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
3.1
yesubabu10203

Hi .i can quickly check this for chances getting optimized This is Yesu ,I am Working as VBA/Python developer for 5 years I work on automations of [login to view URL] [login to view URL] [login to view URL] [login to view URL] Point [login to view URL] [login to view URL](limited) We u Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(11 Commentaires)
3.3
chnsci

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(4 Commentaires)
2.6
agushieduard450

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 scrapin Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
2.2
popnicolaef

Hi there! Hope you are doing well. I've already read your description and understood perfectly about your task. I had vast experience of Excel VBA, VB.net,... So i can provide high quality work as per your requirement. Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
1.7
samarkhan15963

hii ! iam expert for this work .i can complete this work . within set target time frame .iam very honest and responsible parson.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
rm449402

hourly working in bit to 5 in every hours and project completed in 30 bit for 7 days condition apply

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
Srikath0401

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
Lakhansingh911

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0