Ok so here's my delima
I'm pulling info from a web XML, then comparing from the node that matches my base name criteria if that typedvalue and another withing the same node different base name matches the current rows info, if so then pull various data:
any Help as always is appriciated
this is the line that never seems to pass
Here's the Full Sub:![]()
Please Login or Register to view this content.
Here's the XML from the Url:![]()
Please Login or Register to view this content.
Here's a portion of the XML: (I'm comparing SeasonNumber with ("C:" & J) and EpisodeNumber with ("D:" & J) but it doesn't go past the first cell value comparisonHTML Code:
and last but not least the Workbook: (Code located in Episode_ID_Test Module) and running it against Sheet2 for the momentPHP Code:
<Data><Series><id>81189</id><Actors>|Bryan Cranston|Aaron Paul|Dean Norris|RJ Mitte|Betsy Brandt|Anna Gunn|Christopher Cousins|Steven Michael Quezada|Jonathan Banks|Giancarlo Esposito|Bob Odenkirk|</Actors><Airs_DayOfWeek>Sunday</Airs_DayOfWeek><Airs_Time>10:00 PM</Airs_Time><ContentRating>TV-MA</ContentRating><FirstAired>2008-01-20</FirstAired><Genre>|Drama|</Genre><IMDB_ID>tt0903747</IMDB_ID><Language>en</Language><Network>AMC</Network><NetworkID/><Overview>Walter White, a struggling high school chemistry teacher is diagnosed with advanced lung cancer. He turns to a life of crime, producing and selling methamphetamine accompanied by a former student, Jesse Pinkman with the aim of securing his family's financial future before he dies.</Overview><Rating>9.3</Rating><RatingCount>385</RatingCount><Runtime>60</Runtime><SeriesID>74713</SeriesID><SeriesName>Breaking Bad</SeriesName><Status>Continuing</Status><added/><addedBy/><banner>graphical/81189-g20.jpg</banner><fanart>fanart/original/81189-50.jpg</fanart><lastupdated>1352042676</lastupdated><poster>posters/81189-2.jpg</poster><zap2it_id>SH01009396</zap2it_id></Series><Episode><id>3859781</id><Combined_episodenumber>1</Combined_episodenumber><Combined_season>0</Combined_season><DVD_chapter/><DVD_discid/><DVD_episodenumber/><DVD_season/><Director/><EpImgFlag>2</EpImgFlag><EpisodeName>Good Cop Bad Cop</EpisodeName><EpisodeNumber>1</EpisodeNumber><FirstAired>2009-02-17</FirstAired><GuestStars/><IMDB_ID/><Language>en</Language><Overview>Hank and Marie try to spice up their relationship on Valentine's Day.</Overview><ProductionCode/><Rating>6.0</Rating><RatingCount>1</RatingCount><SeasonNumber>0</SeasonNumber><Writer/><absolute_number/><airsafter_season/><airsbefore_episode/><airsbefore_season/><filename>episodes/81189/3859781.jpg</filename><lastupdated>1301948371</lastupdated><seasonid>439371</seasonid><seriesid>81189</seriesid></Episode>
Series_XML_V2.xlsm
Bookmarks