i using "MsXml2.ServerXmlhttp" window function to interact with google doc spreadsheet.
I manage to do some simple add row and edit cell. Now i trying the part "query" then "edit row". As in the Guide, before edit a row , i must do "query" to get ROWID and Version. Google did return me a long xml feed, *How do i extract the info i want? like ROWID and version?* **** I write down ROWID and version at a paper then use it to "edit row" feed and it works. ** Just want a simple way to extract the info i want. Thanks. Steps to reproduce issue: 1. Send query to google spreadsheet using "MsXml2.ServerXmlhttp" 2. Then google will return a xml back the output like below. I just want to get ROWID, version. Is there an easy to extract rowid and version from this long string? <?xml version='1.0' encoding='UTF-8'?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:gsx='http://schemas.google.com/spreadsheets/2006/extended'><id>https://spreadsheets.google.com/feeds/list/0AoOUtxyorVGhdGNONGhFMTB2bWxhQWdfTkk5OEhaUmc/1/private/full</id><updated>2011-03-15T07:17:15.779Z</updated><category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#list'/><title type='text'>Sheet1</title><link rel='alternate' type='text/html' href='https://spreadsheets.google.com/ccc?key=0AoOUtxyorVGhdGNONGhFMTB2bWxhQWdfTkk5OEhaUmc'/><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0AoOUtxyorVGhdGNONGhFMTB2bWxhQWdfTkk5OEhaUmc/1/private/full'/><link rel='http://schemas.google.com/g/2005#post' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0AoOUtxyorVGhdGNONGhFMTB2bWxhQWdfTkk5OEhaUmc/1/private/full'/><link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0AoOUtxyorVGhdGNONGhFMTB2bWxhQWdfTkk5OEhaUmc/1/private/full?sq=sellingprice1%3C40'/><author><name>alexanderlimsoyet</name><email>[email protected]</email></author><openSearch:totalResults>2</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><entry><id>https://spreadsheets.google.com/feeds/list/0AoOUtxyorVGhdGNONGhFMTB2bWxhQWdfTkk5OEhaUmc/1/private/full/cssly</id><updated>2011-03-15T07:17:15.779Z</updated><category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#list'/><title type='text'>ST1</title><content type='text'>sellingprice1: 10, sellingprice2: 2, sellingprice3: 3</content><link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0AoOUtxyorVGhdGNONGhFMTB2bWxhQWdfTkk5OEhaUmc/1/private/full/cssly'/><link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0AoOUtxyorVGhdGNONGhFMTB2bWxhQWdfTkk5OEhaUmc/1/private/full/cssly/42phmhngg'/><gsx:stock>ST1</gsx:stock><gsx:sellingprice1>10</gsx:sellingprice1><gsx:sellingprice2>2</gsx:sellingprice2><gsx:sellingprice3>3</gsx:sellingprice3></entry><entry><id>https://spreadsheets.google.com/feeds/list/0AoOUtxyorVGhdGNONGhFMTB2bWxhQWdfTkk5OEhaUmc/1/private/full/cu76f</id><updated>2011-03-15T07:17:15.779Z</updated><category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#list'/><title type='text'>R</title><content type='text'>sellingprice1: 20, sellingprice2: 2, sellingprice3: 3</content><link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0AoOUtxyorVGhdGNONGhFMTB2bWxhQWdfTkk5OEhaUmc/1/private/full/cu76f'/><link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0AoOUtxyorVGhdGNONGhFMTB2bWxhQWdfTkk5OEhaUmc/1/private/full/cu76f/42pi516md'/><gsx:stock>R</gsx:stock><gsx:sellingprice1>20</gsx:sellingprice1><gsx:sellingprice2>2</gsx:sellingprice2><gsx:sellingprice3>3</gsx:sellingprice3></entry></feed>
