View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JimDandy
 
Posts: n/a
Default Retrieve xml data from SharePoint


I would like to be able to extract data from a series of XML files
contained within a SharePoint library. Each of the XML files have
fields like StartDate, EndDate and checkbox fields that I’d like to
extract. I’ve been able to get a spreadsheet to pull data from one xml
file but I’d like to capture the data from all the files in the
SharePoint library so I can report on the number of forms that meet
certain criteria. What I can’t figure out how to do is to read through
the list and create one row of data per xml form.




--
JimDandy
------------------------------------------------------------------------
JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578
View this thread: http://www.excelforum.com/showthread...hreadid=530536