Find Jobs
Hire Freelancers

Create a VBA app (macro) in Excel 2013 to scrape a manufacturer's website

$30-250 USD

Cancelled
Posted about 7 years ago

$30-250 USD

Paid on delivery
I need a VBA app (macro) to read the SKU in the ProdInfo sheet and for each value, go to the manufacturer's website, find the product listing on their site and extract the product data. The data will include the following: Product Description Product Specifications Product Image(s) Weight (if available) Size (if available) Category or subcategory (if available) Meta Keywords To keep it simple, the drop down box needs to be populated with the Manufacturer's name to be chosen at run time. The data in the ProdInfo sheet will always have the SKU in the first column and there will always be a title in the first row. The program will then loop through the values, open the webpage, search for the SKU and then extract the data into a new worksheet. All superfluous html will need to be removed saving only <p></p> for paragraphs and <ul></ul> for lists. No other formatting is to be saved.
Project ID: 13372175

About the project

21 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
Awarded to:
User Avatar
Hello This is Sourabh Gupta from New Delhi. I am advanced Excel VBA programmer and specialize in creating customized workbooks for businesses and people to meet all their needs efficiently and effectively. Currently, I am at the post of Forum Expert at [login to view URL] with over 400 questions answered. I read the description of your project and would like to offer my services for the same. I have scraped a lot if websites through VBA like [login to view URL] (Bombay Stock Exchange), [login to view URL] (National Stock Exchange of India), [login to view URL], http:// [login to view URL], etc. Not just this there are a lot more I do not have record of at the moment. I can also interact with webpages, like clicking buttons, drop down, logging in, etc. Currently I am doing a project on affiliate marketing which automatically gives ratings to products over 3 websites namely - https:// [login to view URL], [login to view URL], https:// www.onlinediscountshop.com.au. I would like to know more details about your project. I would be glad to answer any of your questions or queries, or if you would like to see some of my past work. Looking forward to a prompt and positive reply from your side :) Best Sourabh
$155 USD in 3 days
5.0 (41 reviews)
4.6
4.6
21 freelancers are bidding on average $163 USD for this job
User Avatar
Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample work before you consider awarding me the project. Thanks, Jay
$200 USD in 3 days
5.0 (562 reviews)
8.2
8.2
User Avatar
Hi, I am good at Web scraping Excel and building useful scripts for my clients. Plz provide me the details of the site to be scrped and excel file. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra
$250 USD in 2 days
5.0 (655 reviews)
7.7
7.7
User Avatar
Hi Sir/Madam. Ready to start. Thanks. Our slogan :  ** What we do, you can find elsewhere ** ** How we do it, makes all the difference **
$155 USD in 3 days
5.0 (455 reviews)
7.5
7.5
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (18+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$155 USD in 3 days
4.9 (231 reviews)
7.3
7.3
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 USD in 3 days
4.9 (235 reviews)
6.9
6.9
User Avatar
Hi I am Excel Expert and VBA Programmer I can write a scraping macro for you If interested, contact me Thanks & Regards
$222 USD in 2 days
4.9 (165 reviews)
7.0
7.0
User Avatar
I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Just FYI, I own a small engineering consulting business registered in the state of Illinois. You could pay me as an individual freelancer or as a business, whichever suits you better. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$200 USD in 3 days
4.7 (200 reviews)
7.1
7.1
User Avatar
Hi: Please share the details of the website. I can develop the scraper in Python or VBA for this task. I have developed several scripts for scrapping. Please note that I have ~100% completion rate and ~5-star feedback on projects. Please connect with me to discuss your requirements in detail.
$150 USD in 4 days
4.9 (162 reviews)
6.9
6.9
User Avatar
Hi, I have more than 14 years of web scarping using Excel/VBA exp. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$150 USD in 3 days
4.8 (158 reviews)
6.5
6.5
User Avatar
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz
$155 USD in 3 days
5.0 (68 reviews)
6.0
6.0
User Avatar
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a hotel price comparison system that pulls data using the website's API - Built a complex shift allowance calendar and calculator - Built a complex lookup to sort products into multiple categories You can see the reviews of the same in my profile
$150 USD in 3 days
5.0 (42 reviews)
5.5
5.5
User Avatar
Hello, I am working with Excel for a long time and I can create complex formulas and macros. I can complete the web scraper for you. If you are interested please open a chat with me. Kind regards, Sorin
$155 USD in 5 days
5.0 (34 reviews)
4.8
4.8
User Avatar
I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon,Cellpex,Costco,Yelp,etc., Hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. Please award me this project and contact me for further details
$166 USD in 4 days
5.0 (57 reviews)
5.0
5.0
User Avatar
Hello, sir! (First Bidder to offer this) I hope I will be awarded from you. ************I agree for any price you will set ** You can test me over chat before you award me! give it a try over chat before you award me! .. you will be %100 satisfied I saw your project and I would like to work on it . I am available 24 hours a day and I have fast response, I will be always there to fulfill your requirement. I always offer low cost and good perfect quality (Just try and see by yourself), I will make you get 100% satisfaction with the best quality service. I will be very happy to work with you, and I hope you too. Thank you
$88 USD in 1 day
5.0 (18 reviews)
4.6
4.6
User Avatar
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
$250 USD in 3 days
4.9 (25 reviews)
4.3
4.3
User Avatar
Dear Sir/Madam, I am good in VBA/Macro in excel. I have done this type of projects in past. Regards, Mastor
$155 USD in 3 days
5.0 (10 reviews)
4.3
4.3
User Avatar
Hi I can do it for you. Recently I did similar thing on MAC even. I am bidding that high as each of your sites will need separate automation to collect data. Your sites are AJAX based which needs automation via Browser / Selenium to be used ... Data collection as well as testing will take time ... However I can guarantee you a success.
$300 USD in 10 days
4.7 (10 reviews)
4.2
4.2
User Avatar
We are team of VBA experts with 5 years of experience. Kindly share the details with us. Looking for your response
$30 USD in 1 day
5.0 (18 reviews)
3.9
3.9
User Avatar
Hi there, I'm interested in the job and can help get it well done with good quality on time. Feel free to contact me and discuss more details. I'm looking forward to hearing from you soon. Best Regards, VL
$120 USD in 2 days
4.9 (11 reviews)
3.7
3.7

About the client

Flag of UNITED STATES
Maryland Heights, United States
5.0
8
Payment method verified
Member since Oct 10, 2011

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.