Getting a string or text from HTML source code to Excel

laytrie

New Member
Joined
Sep 17, 2014
Messages
1
Hi,

My name is Charles and my work is pretty much related to websites. So here is the thing, I have a lot of URL's to look into. For each of the URL it will put me on a comparison site - here is an example of the url Amazon.com: alienware - Computers & Accessories: Electronics

In that URL I need to get the information of how many results were shown. In here there are 17957 results for this keyword.

My file should look something like this:

A1 A2
URL 17957
URL 20
URL 8123

So the steps should something be like:
1. Opens a new IE
2. Gets the first URL
3. Searches through the IE
4. Gets the number of results
5. Pasting the number of results right beside the URL
6. Then proceed to the next until no more URL is available

Would really appreciate comments and suggestions for this.

Thank you very much in advance!
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Forum statistics

Threads
1,222,414
Messages
6,165,892
Members
451,992
Latest member
kaurmanjodh

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