Microsoft Office Tutorials and References
In Depth Information
Table 26-1. Properties and Methods of the Object (continued)
Property or Method
Description
Property
QueryTable
A property used to create a link to a table providing data to the
ListObject .
Range
This property returns a read-only Range object that refers to all the
cells in the ListObject .
SharePointUrl
This read-only property returns a string that contains the URL of
the Microsoft SharePoint list for a given ListObject object.
ShowAutoFilter
A Boolean value that, when set to True , displays the results of the
active AutoFilter on the contents of the ListObject . The default
value is False .
ShowTotals
A Boolean value that, when set to True , displays a Totals row for
the ListObject . The default value is False .
SourceType
A read-only constant that reflects the type of source providing data
to the ListObject . The available data sources are xlSrcExternal (an
external data source such as a Web page), xlSrcRange (a range of
cells in an Excel workbook), and xlSrcXml (an XML data file).
TotalsRowRange
This property returns a read-only Range object that refers to the
cells in the totals row of the ListObject .
XmlMap
This read-only property returns an XmlMap object representing the
schema mapped to the specified list.
Method
Delete
This method deletes the active ListObject and deletes all cell data
associated with it.
Publish(Target(Url,
This method publishes a LinkObject to a SharePoint Services site.
ListName, Description),
The Target argument contains an array of three values: the URL of
LinkSource)
the SharePoint server, the list name, and an optional description.
The LinkSource argument is a required Boolean value that, when
set to True , links the current LinkObject to the published
LinkObject . Setting the LinkSource argument to False means the
two objects won’t be linked (and that any updates to the LinkObject
that called the Publish method won’t be reflected in the LinkObject
on the SharePoint site).
Refresh
This method updates the data and schema for a ListObject that
draws its data from a SharePoint site.
Search JabSto ::




Custom Search