Programming Excel with VBA and .NET

Name

wslists.GetListItems (listName, viewName, query, viewFields, rowLimit, queryOptions)

Synopsis

Gets data from the rows in a list. Returns an IXMLDOMNodeList containing the results of the query.

Argument	Data type	Settings
listName	String	The name or GUID of the list.
viewName	String	The GUID of the view to use when retrieving rows. If omitted, uses the default view.
query	IXMLDOMNodeList	An XML Query element indicating a query to use when retrieving rows.
viewFields	IXMLDOMNodeList	A list of XML ViewFields elements indicating the columns and order of columns to return from the list.
rowLimit	String	The maximum number of rows to return.
queryOptions	IXMLDOMNodeList	An XML QueryOptions element containing other elements used to set the properties of the SPQuery object on the SharePoint server.