How to extract a specific data from a website using macros or vba

I have to note down the no. of reviews from a website page and paste it into excel, Eg: http://www.junglee.com/dp/B00D8WDF22 have 15 reviews on the page and I have to look in the website and write the no of reviews one by one. If the page does not have review then I leave it blank.

Can anyone help me to automate this? It will be very helpful as I have to do this for 1000 products daily


I have attached my excel sheet.

Hello pari9485,

The following macros have been added to the attached workbook. There are in Module1 of the VBA project. A button has been added to the sheet to run the macro.

Module1 Macros

Please Login or Register  to view this content.

Hello pari9485,

After many hours of reading and testing, I have no idea why this is happening. I have saved the page source as a file and edited it several times thinking it could be something in the HTML or JavaScript code. Each edit failed to prevent the Internet Explorer popup. I am running Internet Explorer 10 and according to everything I have read this message should not occur. This was a problem in IE 7 and Microsoft fixed starting with version 8.

I can use this method method to open many other sites with no problem. My best guess is the problem is somehow server related. At this time, I have no workaround to the problem. Perhaps another member has one to offer.