Looping Marco thur url

[sandy armstrong]

Hey Guido,
It been A long time..
I dont know what happened with this code that you helped me delvop. I think the website changed there source code because the marco works but no data is beening imported. I tryed in all the examples that we have copied to this forum and it not working Please Guido call you help me tell what is wrong...
Thanks for you help

[Guido Geurs]

Hello Sandy,
It has been a long time since I have worked on this problem and I don't have the latest code any more (there where also 3 call's on this project).
Please can you attach the workbook with some URL's and the latest macro in?

[sandy armstrong]

OK no problem I have attached the folder Thanks for your help.

[Guido Geurs]

This is a new lay-out for "http://www.careermd.co m/physicians/ViewListing.asp x?ListingID=289 021711"!
Which data do you want from this URL?

This is the only data I get from the 2 tables in it:

table 1 =============== =============== =============
Tampa Hospitalist Opportunity —
Clearwater, Florida
IN Compass Health, Inc. | Morton Plant Hospital
Job ID: 289021711 | J1s Y/N?: Unspecified
=============== =============== =============== ======


table 2 =============== =============== =============
Contact Person: Matt Griffith , Inside Physician Researcher
Phone: (877) 837-0941 ext. , Fax:
=============== =============== =============== ======

[sandy armstrong]

Thanks Guido. I attached the wrong work bok my mistake. I have attached the correct one now what is going on is that the marco that goes into the URL in column K and export the data is working but there is no data being place where it needs to go. that is what leads me to be leave that the website change the source code. PLease let me know what you think. Any help is apperciate.

[Guido Geurs]

Attached is a tool to view the tables in an URL.

HOW:
- Show the Form with the macro : Show_URL_Table_ Viewer

- Paste the URL addresses in column "A"
- Go with the command buttons (UP, LEFT, RIGHT, DOWN) to the Cell with the URL address (not to fast ! = let the sheet the time to update!)
- Click on "GET URL ADDRESS" to put the URL in the textbox
- Select the table number you want to see with the Up and Down spinbuttons.
- Click on "Show URL Table" to load the table in the range = "B1" to "xxxx"

- Click on the Help button to see this help text.

[Guido Geurs]

The data are now in table=7 (check with tool).
Attached is the new code.

[sandy armstrong]

Guido that table finder is soo cool i love how it works. for table3 it would soo neat if it would bring you the email address also. but i know the email is hidden by a types of fire walls. I love this new tools thanks for your help after all this time.