N
Nock
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"?>
<udcataSource MajorVersion="1" MinorVersion="0"
xmlns:udc="http://schemas.microsoft.com/data/udc">
<udc:Name>Project%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:SOAPAction>http://schemas.microsoft.com/sharepoint/dsp/queryRequest</udcs:SOAPAction>
<q:Header xmlns:q="http://schemas.xmlsoap.org/soap/envelope/">
<dsp:versions>
<dsp:version>1.0</dsp:version>
</dsp:versions>
<dsp:request document="content" method="query">
</dsp:request>
<dsp:dataRoot>
<dsp:root>http://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>
</udcataSource>
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"?>
<udcataSource MajorVersion="1" MinorVersion="0"
xmlns:udc="http://schemas.microsoft.com/data/udc">
<udc:Name>Project%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:SOAPAction>http://schemas.microsoft.com/sharepoint/dsp/queryRequest</udcs:SOAPAction>
<q:Header xmlns:q="http://schemas.xmlsoap.org/soap/envelope/">
<dsp:versions>
<dsp:version>1.0</dsp:version>
</dsp:versions>
<dsp:request document="content" method="query">
</dsp:request>
<dsp:dataRoot>
<dsp:root>http://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>
</udcataSource>