extract from web

is it possible to extract the Doctor's Office, Phone Number of all doctors from http://www.suggestadoctor.com/doctor...ma_urology.htm in a new sheet?

OR

if i provide the link address of each doctors in a sheet can i exctract the Doctor's Office, Phone Numbers

means
sheet1 have the following urls
http://www.suggestadoctor.com/doctor...hammontree.htm
http://www.suggestadoctor.com/doctor...s_kolettis.htm
http://www.suggestadoctor.com/doctor...dwin_moody.htm
etc

is it possible to extract the above mentioned items?

result want in sheet2
A1= url
B1= Doctor's Office
C1= Phone Number

any one can help me??

This can be used as an array formula, so assuming the url is in A1, highlight cells B1,C1 and D1 Enter the below formula and hit control + alt + Enter

PHP Code: 

=GetDrDetails(A1) 


Then Drag it down

Please Login or Register  to view this content.

sorry Kyle123 sir
i am new in vba can u explain details
first i enter the three url in a1 cell
then i select BCD
then i enter the equation at the equation bar unfortunately i get a #NAME? error in B1 cell

i copy ur function details and placed it in vba module1
but nothing happend

so can u explain some more detail

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

With 1 url in A1, select cells B1,C1 and D1

Click the address bar and type:

PHP Code: 

=GetDrDetails(A1) 


Press Control + Alt + Enter

as per ur instruction i do everything but after entering the =GetDrDetails(A1) i get an error report
compile error:
wrong number of arguments or invalid property assignment

pls review sir
vData(1) = split(split(.responsetext, "title>")(1)
error shows at after = split

That isn't the code I posted

1. Please use code tags when posting code.
2. What url are you using? It works fine for the urls you listed above:
http://www.suggestadoctor.com/doctor...hammontree.htm
http://www.suggestadoctor.com/doctor...s_kolettis.htm
http://www.suggestadoctor.com/doctor...dwin_moody.htm

i am using the same 3 urls
but did not get the result
can u send me that sample file to me to review, Please.

see attached

This is very easist way to extract
could u please help some more because when i trying ur attached file i get only range B value and not get other two fields
i thought it is a simple misunderstanding of mine.

Have you followed the instructions about entering the array formula?

yes sir
it get corrected when the excel sheet saved as binery workbook

if u dont mind i am notable to findout the " # icon at the top of your post window."
could u help me


also i like to study more about mr kyle123 code
how it possible?

because i need to extract other sites also
the fields are different
expecting ur opinion

IS he extracted based on pagesouce??

Is it possible to collect some more details
Fax # :
Gender
Medical School
Graduation Year
Languages

YES I GOT IT THANK U
ARLU

What i need to do next step to get the answer to the post 17?

i send a msg to kyle but no reply

mr Arul123
what i need to do next?

Please Login or Register  to view this content.

The above codes are written by Mr.Kyle123
i need the following fields also
Dr. Name
Doctor's Hospital
Doctor's Office
Phone Number
Fax Number
Gender
Graduation Year
Location


For getting the gender value i change his code to the below mentioned codes but i did not get the answer
how can i correct it?
Please help

Please Login or Register  to view this content.

any help to move front?