Internet Explorer import to Excel

P

patrick

Am looking for method that allows the importation of multiple pages of a
websearch to Excel for data analyses rather than single pages.
 
F

Frank Kabel

Hi
not really possible. Depends heavily on the data you're trying to
import. Probably requires a script to convert your imported HTML data
 
P

patrick

Thanks for the reply Frank. I was afraid that would be the answer. I have
ran a area code and prefix query to pull up the results of a phone book for a
community. I am trying to find a simple method of exporting the entire query
into excel. One page at a time turns thisinto an arduous process.
 
P

Paul Corrado

With the Data/Get External Data feature and some VBA programming, you can
write a code that extracts the data from the web page and then loops through
the remaining web pages.

(In many instances the URL changes as you click "next page" and there is
some logic to that change that you can incorporate into your code.)
 
Top