Getting data from multiple webpages and posting into one excel sheet

Hi,

I'm working on several law firms. I have profiles of many lawyers and I need to copy their practice area from a part of a web page and transport it to Excel.
The data is available at the same place on all the webpages, but the data obviously differs.
I have a list of the hyperlinks in my Excel Worksheet.
For example:

http://www.babc.com/hal-albritton/
http://www.babc.com/paul-a-alexis/

What I need to do is copy the text under the Service Offered area in an Excel file alongside the hyperlink.

Is there any Macro to achieve this?

Also I have minimal-->no knowledge about macros/VBA/etc.

If anyone can help me out that'll be absolutely fantastic! Thanks in advance!

Do you have ie9 or 10 installed?

I have IE9
But I also have Firefox and Chrome

As a UDF:

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

Please Login or Register  to view this content.

You will need to set a reference to "Microsoft HTML Object Library" - in the VBA screen, go to Tools > references find the library, tick it and press ok.

You will then be able to use this as a normal excel function, so assuming your urls start in A1:

PHP Code: 

=getServices(A1) 


And drag down

Edit: The code is attached as the Forum won't let me post it

Hi, I get what your code's trying to do, but I'm getting an error when I key in getServices -- #VALUE!

Bump (10Char)

Have you added the reference

Yes (10char)

Can you upload your workbook?

Yes, just give me a minute.

Here! Thanks! I really appreciate it!

I just realized that I have by mistake stated that I am using Excel 2010 --- I'm using 2007. Could that make any difference?

Your workbook actually works for me. Try replacing CreateObject("msxml2.xmlhttp") with CreateObject("WinHttp.WinHttpRequest.5.1") and see if it makes any difference. Also, just to be clear, you have ie9, not IE8? This will not work if you only have IE8

Yes, you pointed correctly. I, in fact, have IE 8. Sorry about the confusion. Didn't realize it before.
I'll update it and try again.

Will this work for IE10?

yup 10char

Hi, nope. I'm still getting an error #NAME?

It also says
Static oHtmFile As HTMLDocument
User type not defined

You seem like an Excel wizard! Any further help will be appreciated!

Then you seem to ave removed the reference to HTML object library.

Try this: