Dubai, Excel VBA Pull Data From A Website
Dubai videos | Buildings | Information | History | Emirates | View
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/04/20/excel-vba-pull-data-from-a-website-update/
Comments
-
The site changed too much man, make another video :(
-
Hi, thanks for the great video tutorial. I am trying out a similar website based on your tutorial.
I have a question: what if the website that I am extracting the information from requires an account to login? How do I use VBA to log into an account first then extract information.
Would appreciate if can provide some advise to this:)))) -
Cool :) !
-
hi
I have one doubt hope you can solve it. -
@DontFretBrett
How do I code If I want to pull data from a website containting:
Url, Name, email. phonenumber From say 3000 companies on that website but it should all be automated.
So the program should go through each page and only choose companies having those things? -
Holy cow...that is literally THE most beneficial thing I've learned with regard to VBA. Been working with it for 10 years now, and I just recently came across a need to interact with an HTML page. So, back to Google, which led me here...and now, the world is again, full of endless possibilities!!!
-
it's amazing that it can be done using vba
-
How can I paste the data in two many column
-
hi mate could you possibly help me do a vba for extracting data from the UK DVLA when the reg and make is entered then the car details are assigned.
-
Could you do the same thing but this time extracting a specific stock quote from yahoo finance's website? I can't really understand which part of the html code I need for the macro...
-
YOU ARE GENIUS
-
@DontFretBrett thanks for the wonderful video. can you please help me how to loop this macro. Suppose i want to get only the country name for many zipcode, at this situation how can i loop ?
-
dude you rock
-
Funtastic and searching for this crawler video :D. Thanks +DontFretBrett
-
I'm trying to apply this example to get the price on Amazon but it's not working, could you please make a tutorial for it please ?
-
?
-
How I get mail ID ,phone number ,country, zipcode ,city,districk, from Google ,
-
100thanks
-
Hey! I am trying to pull in API's to calculate distance between two airports. But I have a mac and the office that I have access to, is Office for Mac 2011. The problem I am facing is in calling the 'reference libraries' from the tool Menu. I know they are available in Office for windows but could not trace any info from where they could be fetched/downloaded for Mac. Could you help me here?
Many thanks in advance. -
Thanks man......was looking for something like this. good explanation...
1255Rating