Loading...

Excel VBA Pull Data From A Website

346,558 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Dec 10, 2010

The website has changed since I originally made this video. The state appears to have been removed but you can still get the city and county at least. Change the code from what I say in the video to this:
Dim sDD as string
sDD = Trim(Doc.getElementsByTagName("dd")(0).innerText)
sDD = split(sDD,VbNewLine)(0)
Range("city").Value = Split(sDD,", ")(0)
Range("county").Value = Split(sDD,", ")(1)

A tutorial showing how to pull data from a website. In this tutorial I make a zip lookup that pulls in the city, state and county based on a given zip code. Since posterous closed: http://brettdotnet.wordpress.com/2012...

  • Category

  • License

    • Standard YouTube License

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...