How to stop the internet explore pop up ?

[pari9485]

I have this macro code , It works fine but while it is running internet explorer pops up all the time, Can anyone help to stop is popping up?

I have attached the sheet .Reviews Mapping.xlsm

[Norie]

Try changing the code that deals with the HTML to this, which works.

Please Login or Register  to view this content.

[Leith Ross]

Hello pari9485,

I found the problem!

The authors of the web page made a mistake in the code. The problem is with the placement of a META tag in the code. This tag tells Internet Explorer which version to use. Since it is in the wrong place, Internet Explorer defaults to version 7. Here are the updated macros. The attached file has them added.

Please Login or Register  to view this content.

[pari9485]

Wow, this is awesome, now I can finish my work in minutes Thanks a lot .

[Norie]

pari9485

Just curious, did you try what I suggested?

[pari9485]

the code which you gave didn't help to solve the problem , but i got the solution. Thanks for the help

[pari9485]

I more thing I wanted to ask, If I want to alter this code so that it can take reviews from other websites for eg : http://www.amazon.in/dp/B00CE2LQSW . How can it be done?

[pari9485]

..........................................................................................

[Leith Ross]

Hello pai9485,

I have modified the macro to recognize the URL Amazon India. If present it will extract the review count. Here is the mdified code. The attached workbook contains the change;

Please Login or Register  to view this content.

[pari9485]

Hi Mr.Ross , Although the code is working for Amazon India, but it is not able to detect some of the pages. Some of the pages having reviews are answered as "No review". I have marked them as yellow.Please have a look.

Thanks
Pari