VBA code to scrape Product ASINs with page number from website.

R

ramseyy

New Member
Joined
Feb 18, 2020
Messages
1
Office Version
  1. 2016
Platform
  1. Windows

Amazon.com : disposable mask

www.amazon.com

Amazon.com : disposable mask

www.amazon.com

i tried a vba code to extract the ASINs from the above links for past two days however since im a beginner i couldn't have it extracted.. can any one help me out here to extract the ASINs along with page number and having them on separate sheets i.e page 1 ASINs on one sheet and page two ASINs on second sheet.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
You must log in or register to reply here.

Similar threads

netspeedz
  • Solved
Extracting Data From Kitco.com [Using VBA]
Replies
6
Views
1K
netspeedz
netspeedz
C
  • Question Question
Create code that sends emails and creates a log
Replies
1
Views
265
cokeoverpepsi123
C
L
  • Solved
VBA to automate getting table from website to excel daily
2
Replies
10
Views
3K
John_w
J
G
  • Solved
Intersect Code not working Excel VBA
Replies
2
Views
1K
grabrail
G
Q
  • Question Question
VBA Scrape Data from Website
Replies
2
Views
1K
Dan_W
D

Forum statistics

Threads
1,223,214
Messages
6,170,774
Members
452,353
Latest member
strainu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top