Results 1 to 31 of 31

VBA to Pull specific XML Data from Web

Threaded View

  1. #1
    Registered User
    Join Date
    10-14-2011
    Location
    chesapeake, va
    MS-Off Ver
    Excel 2007
    Posts
    59

    Thumbs up VBA to Pull specific XML Data from Web

    I've seen in other posts specific text value extracted from nodes to cells in a sheet from web xml files

    I'm trying to do the same thing, but am having no success editing VBA I find.

    I have a list of text values, that are used in my url,
    this will be the url :
    "http://api.themoviedb.org/3/movie/" & "IMDBid" & "?api_key=644c8c7523000ff3de7cf4b0af9d4f8c"
    the IMDBid will be the variant

    Then I'm trying to pull Data such as, Original Name, Genre, Rating, Runtime, and eventually inserting images as well. the XML will be formatted like this:http://www.4shared.com/document/RP5DGYvc/tt0362227.html

    I'll then add them to sheet1 on this workbook in cells A1, A2, A3, A4, A5 so on and so fourth as I've done from sheets(Master) in the attached file.
    I have a web query, that does the same thing from IMDB.com, but its slow and painful, where as this method looks to pull quite fast and accurate. how ever, I am so completely lost and at this point frustrated.
    any at all help will be greatly appreciated.


    Movies.xlsm
    Last edited by Spyderz; 10-22-2012 at 05:00 PM. Reason: *Solved --- Thanks Norie!!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1