SharePoint List Web Service

A SharePoint list can only be removed from the server using SharePoint or by using the List Web Service
If you delete a SharePoint list from the server any worksheet lists that are linked to it will generate an error the next time the list is updated or refreshed.

This provides a direct interface to SharePoint lists on the server.

Lets you perform tasks on the server that you can't perform through Excel such as:

• Add an attachment to a row

Dim lws As New clsws_List 
lsw.wsm_AddAttchment 

• Retrieve an attachment from a row

lsw.wsm_GetAttachmentCollection 

• Delete an attachment

lsw.wsm_DeleteAttachment 

• Delete a list

• Perform queries

lsw.wsm_GetListItems 

results are returned in XML
using an XML query file