XML - VBA conversion (.uxdc file)
 

Hi,

I am attempting to export data from a Windows Sharepoint site for the
purpose of creating a report. Using Excel 2003 a user can connect to a
particular site using a .uxdc file, however I need to be able to access each
site programmatically using a VBA userform.

Any ideas as to whether it's possible to convert the following code to VBA?

Many thanks,

Nock

(Below is a .uxdc that queries the 'P3-Emp3' project Issues list.)

<?xml version="1.0"?
<udc:DataSource MajorVersion="1" MinorVersion="0"
xmlns:udc="http://schemas.microsoft.com/data/udc"
<udc:NameProject%20Issues</udc:Name
<udc:Type Type="SOAP" MajorVersion="1" MinorVersion="0"
<udc:SubType Type="DSP" MajorVersion="1" MinorVersion="0"
<udc:SubType Type="STS" MajorVersion="1" MinorVersion="0"
</udc:SubType
</udc:SubType
</udc:Type
<udc:ConnectionInfo Purpose="Query"
xmlns:udcs="http://schemas.microsoft.com/data/udc/soap"
xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp"
<udcs:Location
href="http://p3-epm3:3344/_vti_bin/dspsts.asmx"STSDataAdapter</udcs:Location

<udcs:SOAPActionhttp://schemas.microsoft.com/sharepoint/dsp/queryRequest</udcs:SOAPAction
<q:Header xmlns:q="http://schemas.xmlsoap.org/soap/envelope/"
<dsp:versions
<dsp:version1.0</dsp:version
</dsp:versions
<dsp:request document="content" method="query"
</dsp:request
<dsp:dataRoot
<dsp:roothttp://p3-epm3:3344</dsp:root
</dsp:dataRoot
</q:Header
<q:Body xmlns:q="http://schemas.xmlsoap.org/soap/envelope/"
<dsp:queryRequest
<dsp:dsQuery select="/list[@id='{7147F5B7-BE43-48B7-AF5F-6907CEFE8590}']"
resultContent="dataOnly" resultRoot="Project Issues"
<dsp:Query
<dsp:Fields
<dsp:Field Name="Title"/
<dsp:Field Name="AssignedTo"/
<dsp:Field Name="Created"/
<dsp:Field Name="Category"/
</dsp:Fields
</dsp:Query
</dsp:dsQuery
</dsp:queryRequest
</q:Body
</udc:ConnectionInfo
</udc:DataSource