ListObject.SharePointURL Property

Syntax

expression.SharePointURL

expression A variable that represents a ListObject object.

Remarks

Accessing this property generates a run-time error if the list is not linked to a SharePoint site.

Example

The following example sets elements of theparameter of the Publishmethod to push the ListObjectobject to a SharePoint site. The code sample uses the SharePointURLproperty to assign the URL to the array and the Nameproperty to assign the name of the list. The information in the array is then passed to the SharePoint site using the Publishmethod.

Sub PublishList() Dim wrksht As Worksheet Dim objListObj As ListObject Dim arTarget(4) As String Dim strSTSConnection As String Set wrksht = ActiveWorkbook.Worksheets("Sheet1") Set objListObj = wrksht.ListObjects(1) arTarget(0) = "0" arTarget(1) = objListObj.SharePointURL arTarget(2) = "1" arTarget(3) = objListObj.Name strSTSConnection = objListObj.Publish(arTarget, True) End Sub 

See also:

• ListObject Object
• ListObject Object Members