import data from website to excel

[anilg0001]

hai every one
me anil a newcomer in excel vba code
i want to import details from the site
http://www.thirdage.com/d/dr/spc-157/plastic-surgeons
from this site
first i want to go alabama
then albester
then miles selected as 20 then select submit
from the new desk i want to import from four pages like
a1= Alexander Garry Nein, MD
b1=(615) 327-0201
to upto the end

then again change the city as Alexander City
and same procedute.
any know how to import?

 

[wigi]

Hello there,

I would like to tell you that these kind of problems (getting data from the web) are a huge time saver if one needs to do this manually. But equally valid, they require a significant amount of work to set up for a coder/helper.

This is equivalent to your earlier question:

http://www.mrexcel.com/forum/showthread.php?t=481817

So please be aware that help might come late or even not. You are asking quite some effort in terms of time and knowledge.

To get you starting to write code yourself and experiment, have a look at:

http://effectivemsofficesolutions.com/VBA/VBAWebScraping.html

Wigi

 

[anilg0001]

but it is not from a table sir.

 

[wigi]

No sir, but it shows how to automate Internet Explorer, and it shows also that you can use elements of the Microsoft HTML Object Library if you use the correct references.

 

[anilg0001]

u make me sad

 

[wigi]

u make me sad

I am very sorry but it ain't different.

I hope someone else has the time and wants to code all this for "you" (instead of "u").