VBA Data Scraping - YellowPages, Google & Website

Hi, I need an Excel VBA guru to take the following columns as inputs and conduct web data scraping.

Inputs in Excel:

- Company Name

- Location (e.g. NSW)

VBA Process & Outputs in Excel:

Google Search:

1. Google Search the Company Name

2. Extract information from First Search result (Header, URL, Description)

3. Copy Each into a separate Column

Google Search + Website Scrape:

4. Google Seach 'Company Name' and "About Us"

5. Click on the first result

6. Copy website contents into one cell (potentially grab all <p> Elements)

Yellow Pages Search & Scrape:

7. Search [login to view URL] for Company Name & Location

8. Click on First Result

9. Copy (Company Name, Industry Categorisation, Phone Number, Email, Website URL, Physical Address, ABN, About Us) - Some may be missing which is ok to leave blank

10. Paste into separate Columns.

GUI & Code Readability:

Preferably to have all code appropriately commented on what it's doing

Prefer GUI buttons with Run, Pause, Stop.

Skills: Data Mining, Data Scraping, Excel, VBScript, Web Scraping

See more: Data Scraping of Sports Website - Basketball Data -- 2, face fun photoshop editing, data scraping import magento website, data scraping vba code, data scraping google keyword tool, fun photoshop photo editing, fun photoshop editing, fun photoshop, photo fun photoshop, web data scraping vba, google data scraping, website data scraping visual basic, vba data google finance, photoshop projects fun, photoshop fun website, google finance stock data scraping linux, fun projects photoshop, fun pet photoshop projects, design fun photoshop, photoshop template wigs fun

About the Employer:
( 12 reviews ) Nundah, Australia

Project ID: #13198827

16 freelancers are bidding on average $116 for this job


Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can do VBA Data Scraping - YellowPages, Google & Website. I have always created a long-term More

$150 AUD in 10 days
(319 Reviews)

Hello , I have read your project description and understood your requirement. I have 5 years experience in Web scrapping and can complete task within time with 100% accuracy.I will develop a VBA code with GUI buttons a More

$150 AUD in 3 days
(403 Reviews)
$100 AUD in 1 day
(307 Reviews)

A proposal has not yet been provided

$111 AUD in 2 days
(170 Reviews)

Dear Sir, I'm very much delighted to let you know that i did data scraping with PHP-cURL, PhantomJS, Node.js, Selenium from many sites. I just scraped the data from web site and then wrote the data in mysql database More

$277 AUD in 10 days
(64 Reviews)
$50 AUD in 1 day
(176 Reviews)

Hello, I have my own software. I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think More

$88 AUD in 10 days
(103 Reviews)

A proposal has not yet been provided

$150 AUD in 1 day
(54 Reviews)

I am very able to create this script to scrap data - also i have this data all ready to deliver

$99 AUD in 3 days
(63 Reviews)

Hello, i am expert in this kind of jobs i finished 10 scraping jobs in this year More

$50 AUD in 2 days
(40 Reviews)

Dear client, I have read the description and can build a scrapper with GUI using Excel VBA. I have previously done such projects and can showcase it to you. Looking forward

$133 AUD in 3 days
(13 Reviews)

Data entry & Web Scraping expert here with fastest speed. PAYMENT AFTER YOU 100% SATISFIED WITH WORK. ready to start your work now and will work with your 100% satisfaction....................... 9 Year Experience i More

$100 AUD in 1 day
(8 Reviews)

Respected Client , I have read the project description and is willing to work under your budget and on required time. Also , i have worked on project like these before it will be very easy for me to fulfill your ex More

$25 AUD in 10 days
(14 Reviews)

PROFESSIONAL LEAD GENERATOR WITH PREMIUM LINKEDIN Hello. I have rich experience in web researching and data scraping. I'll give you only qualitative data I am keen on using a certain number of tools, like extension More

$166 AUD in 10 days
(6 Reviews)
$88 AUD in 10 days
(2 Reviews)

Hello, I have extensive scraping experience. I can complete your work and then you can pay. So that you have zero risks of losing money. Can we have more discussion?

$111 AUD in 1 day
(0 Reviews)