OfficeDataSourceObject.Table Property - PowerPoint

Gets a String that represents the name of the table within the data source file that contains the mail merge records. The returned value may be blank if the table name is unknown or not applicable to the current data source. Read-only.

Syntax

expression.Table

expression A variable that represents an OfficeDataSourceObject object.

Example
This example sets the name of the table if the table name is currently blank.

Visual Basic for Applications

Visual Basic for Applications
`Sub OfficeTest() Dim appOffice As OfficeDataSourceObject Set appOffice = Application.OfficeDataSourceObject appOffice.Open bstrConnect:="DRIVER=SQL Server;SERVER=ServerName;" & _ "UID=user;PWD=;DATABASE=Northwind", bstrTable:="Employees" If appOffice.Table = "" Then appOffice.Table = "Employees" End If End Sub`

Sub OfficeTest() Dim appOffice As OfficeDataSourceObject Set appOffice = Application.OfficeDataSourceObject appOffice.Open bstrConnect:="DRIVER=SQL Server;SERVER=ServerName;" & _ "UID=user;PWD=;DATABASE=Northwind", bstrTable:="Employees" If appOffice.Table = "" Then appOffice.Table = "Employees" End If End Sub

ofv table table property

See also: