Closed

Data scraping with Excel VBA

I need to have an Excel spreadsheet programmed to scrap data from AirBnB daily.

Once a button is pressed / macro is programmed to run daily, the following information will be collected from England, Wales, Spain and the Canary Islands (Fuerteventura, Lanzarote, Gran Canaria, Tenerife):

• All listings booked for the day

o The price they have been booked for

o How many bedrooms they have

o Location (city & country)

o The name of the listing on AirBnB (so I can search for it and view it)

• All listings that have not been booked for the day

o The price they have been booked for

o How many bedrooms they have

o Location (city & country)

o The name of the listing on AirBnB (so I can search for it and view it)

• The front sheet will contain multiple dropdown boxes of the country’s to collect the data from

• The front sheet will contain a time that the macro is to run – it will run daily at the time

• The front sheet will contain a ‘start button’ to begin running the macro

• The front sheet will contain a dropdown with two options – automated / manual

o The ‘start button’ will only work when the dropdown is set to manual

o The automated macro will only run when the dropdown is set to automated

Each day of data collection will involve the macro creating a new sheet for the day of data.

Skills: Data Processing, Data Scraping, Research, Market Research, Excel

See more: vba web scraping tutorial pdf, vba web scraping kit, excel vba scrape table from website, vba web scraping chrome, vba web scraping login, excel vba pull data from a website, automatically pull data from website into excel vba, excel vba web query, getting data msaccess excel vba, search data csv excel vba, deleting data clipboard excel vba, create data files excel vba, resume pharma sales data reporting excel vba developer, web data parse excel vba, web scraping excel vba, refreshing data web excel vba, retrieve data database excel vba, data entry excel vba, fast data entering excel vba, copy data website excel vba

About the Employer:
( 24 reviews ) Knottingley, United Kingdom

Project ID: #21872584

31 freelancers are bidding on average £146 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g More

£250 GBP in 3 days
(720 Reviews)
8.5
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

£170 GBP in 3 days
(317 Reviews)
7.9
zekovicm

Hi there,I am Web Scraping(Excel,python ) expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finis More

£215 GBP in 5 days
(140 Reviews)
7.4
motiur03

Dear Hiring Manager, I have read through your project description. I am ready to do some free sample for you. Message me so we can discuss more. You may see my profile here: https://www.freelancer.com/u/motiur03.html More

£135 GBP in 3 days
(251 Reviews)
7.4
SShtv

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These More

£250 GBP in 7 days
(82 Reviews)
6.0
citijayamala

1. I am an expert in Excel, VBA, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many proje More

£150 GBP in 3 days
(89 Reviews)
5.9
StormLion227

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on freelancer.com and I do not More

£150 GBP in 3 days
(32 Reviews)
4.7
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse More

£85 GBP in 1 day
(25 Reviews)
4.7
yashashahj1397

hi i saw you your post regarding web scraping.i have done many similar tasks like this i can make a scraper for you maybe i can add a feature like scraping particular data from website and save into excel or csv or in More

£135 GBP in 7 days
(12 Reviews)
4.3
michaels225

It's a piece of cake for me. Hi, sir. I am a Web scraping expert. I have many experiences like your project. I am very confident to complete this task in a few days. I am ready for your project and I will provide the b More

£110 GBP in 2 days
(7 Reviews)
4.0
chintuag

Dear Hiring Manager, I have read the job description and understand your requirements. I have worked on similar data scraping projects, providing users with a front end to select options from and scrape data basis More

£178 GBP in 4 days
(7 Reviews)
3.8
polite90

Hi, I have rich experience with VBA and Excel. I have done many web scraper with VBA. VBA is convenient to output the scraped data into excel directly. I can do it in one day. Hope to work with you

£150 GBP in 1 day
(4 Reviews)
4.2
qasimalikgmail

Dear client, I went through the requirements and I can build a scraping tool using Excel VBA that will fulfill all of them. The tool will also provide you a very user friendly interface for choosing country, automated/ More

£200 GBP in 7 days
(7 Reviews)
3.7
smsaurabhv

Hi, I have gone through your requirement to scrape lots of websites. I am EXPERT in building scraping tools /scripts. Hence, I can SURELY work on your project. I am having 4 YEARS of EXPERIENCE in developing PHP-PYTHON More

£111 GBP in 3 days
(13 Reviews)
3.8
wkcompany

Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many More

£60 GBP in 1 day
(18 Reviews)
3.3
MikaMcLeod

For other different types of Data scraping with excel VBA and writing you may require, my flexibility and willingness to learn to give me an added advantage. I am excited whenever I have to take on a challenge that I h More

£200 GBP in 3 days
(5 Reviews)
3.2
jinridong19713

Hi. Sir Thanks for your post. I am interested in your project. I am a expert who have many experiences in Excel, Vba If you hire me, I can complete this project in short time as you want. I can start working right now. More

£135 GBP in 7 days
(2 Reviews)
2.2
seoexperttarik71

I have read your project description. I have lots of experience in this sector. I think I can do this project in your budget range within your expected time perfectly. Please Discuss with me for once before you give th More

£135 GBP in 7 days
(5 Reviews)
2.4
Excelologist

Hi, I am an experienced professional in Automation on MS Excel, through VBA/Macros. I create Macro-Enabled Excels, Google spreadsheets, Add-ins and generate various reports from it. I have also delivered many projects More

£200 GBP in 7 days
(1 Review)
2.0
luckzone2275

HI, I understand you are looking for accurate and experienced hands with good knowledge of, Copy Typing, Data Entry, Excel, PDF, Word an experienced person with good knowledge of Excel and can put in regular and ful More

£20 GBP in 1 day
(0 Reviews)
0.0