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

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,224,798
Messages
6,181,038
Members
453,014
Latest member
Chris258

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