XML data into excel

Hey all,
What I'm ALMOST doing is getting the XML data(grid, name, address) for a given callsign for my excel logbook. The route I'm using is data connections and 2 different IGY files. The first sends my id and password and returns the session id. The second is tied to a cell with the callsign to lookup and the cell I store my session in. It returns ALMOST everything, but never returns the state or zip and the last name only for certain callsigns. Has anyone else done this successfully? I'm pretty good with Excel, but this aspect is a bit new to me.

I'm using Excel 2007 on win 7, and vista. My IGY file for the lookup request is :

WEB
1
http://xmldata.qrz.com/xml/current/?
s=[];callsign=[]

or
WEB
1
http://xmldata.qrz.com/xml/current/?s=[];callsign=[]


Both return the same info.


If you have any suggestions, I'd appreciate it!

73,
Tery Johns
KD8GNC

 

Well, thanks for looking, all. At least I feel better when no one else has a clue either! ;-)

73
TJ
KD8GNC