Search notes:

Excel Object Model: OLEDBConnection

Methods and properties

ADOConnection
alwaysUseConnectionFile
application
backgroundQuery
calculatedMembers
cancelRefresh
commandText The command to be executed on the data source which provides data via the OLEDBConnection object to the consumer. The value can be an SQL statement (See commandType property)
commandType A member of the the xlCmdType enumeration (xlCmdCube, xlCmdDAX, xlCmdDefault, xlCmdExcel, xlCmdList, xlCmdSql, xlCmdTable, xlCmdTableCollection)
connection
creator
enableRefresh
isConnected
localConnection
localeID
maintainConnection
makeConnection
maxDrillthroughRecords
OLAP
parent
reconnect
refresh
refreshDate Returns the date when an OLAP data source was last updated.
refreshing
refreshOnFileOpen
refreshPeriod
retrieveInOfficeUILang
robustConnect
saveAsODC
savePassword
serverCredentialsMethod A member of the xlCredentialsMethod enumeration (credentialsMethodIntegrated, credentialsMethodNone, credentialsMethodStored)
serverFillColor
serverFontStyle
serverNumberFormat
serverSSOApplicationID
serverTextColor
sourceConnectionFile
sourceDataFile
useLocalConnection

See also

The OLEDBConnection property of the WorkbookConnection object.
Excel Object Model

Index