ExcelBanter - I want to create lists from web pages

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - I want to create lists from web pages (https://www.excelbanter.com/excel-programming/417099-i-want-create-lists-web-pages.html)

I want to create lists from web pages

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.

I want to create lists from web pages

You could use Dataimport 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"
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sevada" wrote in message
...
http://ca.allpages.com/burbank/healt...professionals/

THe local listings, 667 names...

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sevada" wrote in message
...
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.