Use the Lists Web Service
SharePoint Services includes the Lists Web Service for getting at shared lists and their data directly. The Lists Web Service lets you perform tasks on the server that you cannot otherwise perform through Excel objects; you can use it to:
Add an attachment to a row in a list
Retrieve an attachment from a row in a list
Delete an attachment
Delete a list from a SharePoint server
Look up a list GUID
Perform queries directly on the shared list
To use a web service from Visual Basic:
Figure 14-8. The Web Services Toolkit in action
The SharePoint Web Services reside in the _vti_bin folder of the SharePoint site. To use the Lists Web Service:
Display the Microsoft Office 2003 Web Services Toolkit as described earlier.
Select the Web Service URL option button and type the address of the address using this form: http://sharepointURL/_vti_bin/lists.asmx.
Click Search. The toolkit should find the Lists Web Service and display it in the Search Results list.
Select the checkbox beside Lists in Search Results and click Add.
The toolkit generates a proxy class named
clsws_Listsand adds it to the current project. ...