Find Jobs
Hire Freelancers

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

$30-250 USD

Скасований
Опублікований about 7 years ago

$30-250 USD

Оплачується при отриманні
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.
ID проекту: 13372175

Про проект

21 пропозицій(-ї)
Дистанційний проект
Активність 7 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
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 за 3 дні(-в)
5,0 (41 відгуки(-ів))
4,6
4,6
21 фрілансерів(-и) готові виконати цю роботу у середньому за $163 USD
Аватарка користувача
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 за 3 дні(-в)
5,0 (562 відгуки(-ів))
8,2
8,2
Аватарка користувача
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 за 2 дні(-в)
5,0 (655 відгуки(-ів))
7,7
7,7
Аватарка користувача
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 за 3 дні(-в)
5,0 (455 відгуки(-ів))
7,5
7,5
Аватарка користувача
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 за 3 дні(-в)
4,9 (231 відгуки(-ів))
7,3
7,3
Аватарка користувача
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 за 3 дні(-в)
4,9 (235 відгуки(-ів))
6,9
6,9
Аватарка користувача
Hi I am Excel Expert and VBA Programmer I can write a scraping macro for you If interested, contact me Thanks & Regards
$222 USD за 2 дні(-в)
4,9 (165 відгуки(-ів))
7,0
7,0
Аватарка користувача
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 за 3 дні(-в)
4,7 (200 відгуки(-ів))
7,1
7,1
Аватарка користувача
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 за 4 дні(-в)
4,9 (162 відгуки(-ів))
6,9
6,9
Аватарка користувача
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 за 3 дні(-в)
4,8 (158 відгуки(-ів))
6,5
6,5
Аватарка користувача
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 за 3 дні(-в)
5,0 (68 відгуки(-ів))
6,0
6,0
Аватарка користувача
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 за 3 дні(-в)
5,0 (42 відгуки(-ів))
5,5
5,5
Аватарка користувача
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 за 5 дні(-в)
5,0 (34 відгуки(-ів))
4,8
4,8
Аватарка користувача
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 за 4 дні(-в)
5,0 (57 відгуки(-ів))
5,0
5,0
Аватарка користувача
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 за 1 день
5,0 (18 відгуки(-ів))
4,6
4,6
Аватарка користувача
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 за 3 дні(-в)
4,9 (25 відгуки(-ів))
4,3
4,3
Аватарка користувача
Dear Sir/Madam, I am good in VBA/Macro in excel. I have done this type of projects in past. Regards, Mastor
$155 USD за 3 дні(-в)
5,0 (10 відгуки(-ів))
4,3
4,3
Аватарка користувача
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 за 10 дні(-в)
4,7 (10 відгуки(-ів))
4,2
4,2
Аватарка користувача
We are team of VBA experts with 5 years of experience. Kindly share the details with us. Looking for your response
$30 USD за 1 день
5,0 (18 відгуки(-ів))
3,9
3,9
Аватарка користувача
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 за 2 дні(-в)
4,9 (11 відгуки(-ів))
3,7
3,7

Про клієнта

Прапор UNITED STATES
Maryland Heights, United States
5,0
8
Спосіб оплати верифіковано
На сайті з жовт. 10, 2011

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.