Amazon Product Scraping VBA Code completion help.

[nomi2565]

Hi folks

I need help to complete the VBA code to scrape Amazon pages by using Excel,

In column A (Link) I paste the product address (i am unable to post on this forum)
In column B , I would like to scrape the Product name ("Seagate Portable 1TB External Hard Drive HDD – USB 3.0 for PC Laptop and Mac (STGX1000400)" in this case)
In column C, I would like to scrape the product price ("which is $44.99" in this case)
In column D, I would like to scrape the AmazonGlobal Shipping ("$42.85" in this case)
In column E, I would like to scrape the Estimated Import Fees Deposit ("$18.02" in this case)

I will be adding around 372 links to column A and would like the other column to do the same throughout.

Here is the incomplete code:

Please Login or Register  to view this content.

Please comlete this code so i could get the desired results.
Thanks in advance.