I want to create lists from web pages

[Sevada]

I have a question on how I can automate the process of cuting and pasting
addresses into excel from webpages that have contact information like
address, phone and fax number?

If anyone had suggestion, I would appreciate the help. I am using Office
2007 Pro.

 

[Don Guillett]

Examples of url(s) and what info you want from where.

 

[Sevada]

http://ca.allpages.com/burbank/health-medical/healthcare-professionals/

THe local listings, 667 names...

 

[Don Guillett]

You could use Data>import external data>>>>>
import the entire page and use a macro to extract to another sheet. Loop
thru all to get the entire list. It would require a bit of coding and
testing to get it right but it could then be ONE mouse click to get all at
once.
This is the sort of thing I have done for clients in the past.

"URL;http://ca.allpages.com/burbank/health-medical/healthcare-professionals/index-4.html"