Find Jobs
Hire Freelancers

Web Scraping using VBA in Excel

$30-250 USD

In Progress
Posted over 7 years ago

$30-250 USD

Paid on delivery
I am looking for a really good VBA coder who can work with me long term and speaks really good English and works all throughout the day as I know there is a big time change. This first project is web scraping but there may be many projects in the future that is just VBA coding. THE USERS OF THIS WILL BE USING A MAC AND THEREFORE CODE NEEDS TO RUN IN MAC ALSO I need to scrape the following website [login to view URL] Here are the steps: Add button on page to run the scrape. Step 1: Attached list has numbers/letters in column A that need to be entered into the search bar. Once searched, there will be many results. Click on the first result. If you scroll down to the claims section you will see that there may be many claims for a given result. Step 2: Column B will have which claim number I want scraped. We will only scrape up to 20 total claims. Usually there will be 7 or less that I want scraped. I will have a number followed by a comma for each claim. The very first one is 1,8 so I would want to scrape Claim 1 and Claim 8 like the example has. Step 3: If a number/text in column A is not found, I do not want the code to break. Simply put "No data found" in Column C Claim 1. If a specific claim number is not found such as Claim 8 I want a message to appear in the column that says "Claim 8 Not Found". The claim number does not mean it has to go in a specific column. If I provide 5 claim numbers in column B, the 5 claims should go in column C-G. If the second claim number provided is not found, the error message should occur in column D as that is the second column where a claim should be entered.
Project ID: 12994511

About the project

18 proposals
Remote project
Active 7 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
18 freelancers are bidding on average $273 USD for this job
User Avatar
Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and doing the project. Best regards, Eyad
$578 USD in 15 days
5.0 (26 reviews)
6.9
6.9
User Avatar
Hi , I went through the job. I can complete this job within a day. I would use Java technology to do the scraping. Please let me know . I have 10+ years of experience in data entry,Webscraping , Excel & VBA. Please check my past reviews and ratings. Please ping back to discuss the requirements. I can give you demo job so that you are 100% confident about my ability to complete the job. Why i should be Hired ? I have very good experience 100% job accuracy . 100% Time compliance Good Communication I am sincere,honest and hardworking independent freelancer. I give more importance to the job than $. Please let me know your email id for ease of communication . Thank You. Regards, Rishi
$100 USD in 1 day
4.9 (151 reviews)
5.9
5.9
User Avatar
Hi, I read your job requirements.I understand the job very well and willing to do it. I can do it perfectly. Please give me details to start this jobs/works.I have done lots of similar jobs in past, you can check my reviews. Regards PerfectChoic3
$133 USD in 2 days
4.8 (55 reviews)
5.7
5.7
User Avatar
Hi, Hope you are doing well. I have reviewed the project description and able to create a program/scraper to scrape the claim information from the given website and update it into excel file according to the provided instruction. I make sure you that the task Will be completed on budget and on time as well. Rest we may discuss thru Chat session. Thank you
$200 USD in 3 days
4.9 (64 reviews)
5.3
5.3
User Avatar
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 or excel or csv or xml file. I worked on many similar projects, I have big experience in data mining projects. I have written hundreds of web scrapers which scrape millions of pages each day. I'm ready to fulfill your requirement. I can finish this task in short time, with the best quality. I can assure 100% accuracy. Please give me the opportunity to do the work. With Kind Regards, Debdulal Roy Proshanta
$155 USD in 3 days
4.9 (13 reviews)
5.2
5.2
User Avatar
I have 10 years experience with Data Processing in Excel and Web Researching. I work with: Web Search Web Scrapping Excel Access PowerPoint Finance Management Statistics Data Processing Data Collecting (Using Macro) MS Office C++ HTML VBA Mathematics Excel VBA Macro Automation User Forms Data Analyzing PivotTable Chart Graphic Presentations Photoshop Data Presentations And any task related to Excel Feel free to contact me.
$80 USD in 3 days
4.9 (42 reviews)
5.2
5.2
User Avatar
Hello Dear Sir how are you hope you are well Dear Sir I am An Expert Data Scraper I Have a Scraping Tool (Scraper). I Can Scrap Any website and thousands of products in very short time if you Really want 100% Error Free and Quality Work Done Then Please Hire me for this Web scraping job I Can send you a sample sheet from my last data scraping project That I did complete Recently for my client from USA I Can scrap more then 100000 products daily Thanks
$250 USD in 2 days
4.7 (21 reviews)
5.0
5.0
User Avatar
A proposal has not yet been provided
$200 USD in 5 days
4.9 (11 reviews)
3.7
3.7
User Avatar
I can certainly do this. I have done scraping using vba, perl and python. Please ping me if you want to discuss anything before awarding this job. Thanks, Rajeev
$200 USD in 7 days
4.6 (14 reviews)
4.1
4.1
User Avatar
Hi. I have created many scraper softwares. I can make a scraper for this site as you request. I can start right now Hi. I am an expert in Excel VBA, VBScript, Visual Basic, C#. I can create auto scripts to format txt, csv, xlx, xlsx files as you request. I can start right now
$200 USD in 3 days
4.4 (19 reviews)
3.8
3.8
User Avatar
Hi, I propose to use R programming language as it can help you to do the task. It can read input file from Excel and mine web data too. Thank you.
$277 USD in 10 days
5.0 (3 reviews)
2.8
2.8
User Avatar
I have sound experience (5+ years) in Excel/MS Access/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy.
$77 USD in 3 days
5.0 (3 reviews)
2.4
2.4
User Avatar
Hi i am an experienced developer have completed many projects like this. I will complete your project with 100% money back guarantee.
$1,300 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Chicago, United States
5.0
49
Payment method verified
Member since Apr 23, 2014

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.