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
Bookmarks