ListObject.Publish (Excel)

Publishes the ListObject object to a server that is running Microsoft SharePoint Foundation.

The Target parameter contains an array of String elements, as described in the following table.

Publish (Target, LinkSource)

Dim strTarget() As String: strTarget() = 
Dim strPublish As String
strPublish = ActiveCell.ListObject.Publish(Target:=strTarget(), LinkSource:=True)

Arguments

The following arguments are required:

Target (String) - Contains an array of String values, as described in the Remarks section.

LinkSource (Boolean) - See the Remarks section.