Create VBA code to scrape a website and save specific data from each page

We are a distributor for TecNiq LED products and we are working to get their products on our website. Their data is not structured well enough for us to easily add their products to our website. For this project I need the following elements saved from each product page:



Part Numbers

Downloads (if available)

For this project, you will write a VBA script for Excel that will go through the website and extract this data and create an Excel workbook with the HTML from each tab in a cell along with the item's main part number. For example, for item D21 ([url removed, login to view]), the code should capture and store the HTLM from each tab on the page. I want only the HTML, nothing more.

This is a very simple project and I will pay $40 for the Excel VBA code.

Skills: Excel, Visual Basic, Visual Basic for Apps, Web Scraping

See more: vba getelementsbytagname("href"), vba getelementsbytagname count, vba code to import data from website to excel, ie.document.getelementsbytagname vba, vba get elements by id, vba getelementsbyname, excel vba getelementsbyclassname, excel vba get elements by tag name, Code Cleanup | Website speed optimization (on page & server side), vba code to extract data from website, create html code for website, vba code scrape website, excel vba code scrape data website, scrape website data access, scrape website data csv input, extract specific data website excel, excel vba script scrape website, vba script scrape data website, create html code facebook website, website data page

About the Employer:
( 8 reviews ) Maryland Heights, United States

Project ID: #15889207

Awarded to:


Hi.. I have gone through your project details and would like to take an opportunity to work on it. Being experienced in working on data scrapping and excel vba tasks, I can help you in getting it done quickly and effic More

$35 USD in 2 days
(75 Reviews)

12 freelancers are bidding on average $60 for this job


Greeting, I have understood your Create VBA code to scrape a website and save specific data from each page task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 More

$140 USD in 3 days
(225 Reviews)

Dear sir, I am scraping expert. I have did more than 350+ scraping projects. Can we discuss more details about your project? then i can do example data or script for you, we can continue after you checked example More

$134 USD in 3 days
(238 Reviews)

Hello. I have opened this website and I have found it's not so complicated to extract information from there. Also, I have experience with scraping HTML pages from Excel VBA

$40 USD in 3 days
(327 Reviews)

Hi, I have more than 14 years of Excel/VBA exp. Let us discuss more details so that I can estimate cost and time better. I have completed more than 310 projects. Please look at the feedback left by my em More

$40 USD in 4 days
(131 Reviews)

Hi I went through the project description .I can complete the job within few hours. Please ping back to discuss. Do you need VBA source code or only data is required ? I would first create a tab to create list of pro More

$66 USD in 1 day
(143 Reviews)

Hi I have a team of 7 members, expert in web scraping manual& automatic data collection& excel work.I understand the requirements of your project and I can assure you of completion with desired quality of work. I have More

$50 USD in 1 day
(140 Reviews)

I have 7 years of experience Excel VBA and Web scrapping with 100% client satisfaction history. ill develop code which will scrap all the product info in Excel. See my profile for client reviews about me.

$40 USD in 0 days
(35 Reviews)

Hello I have major experience working on web scraping jobs using VBA so I believe I can help you. I can create a workbook where you paste in the first sheet the list of products and by clicking a button you scrape a More

$40 USD in 3 days
(38 Reviews)

Dear Hiring Manager, I am an expert in excel and have worked on various automation projects. My skills includes, but not limited to: Macros, Web Scraping, User Forms, Dashboards, Pivot Tables, Formulas, Customized Ri More

$45 USD in 2 days
(9 Reviews)

I am not a random bidder... Could you please provide the URL and other detials..Please ping me if you are interested wtih my proposal and thank you...

$50 USD in 3 days
(15 Reviews)

I have coded and executed many VBA web scraping scripts, mostly from more complex sites. My script is going to require the addon "selenium for vba". It's a simple process, but I am going to provide an intallation guid More

$45 USD in 3 days
(4 Reviews)