ODBCConnection.SaveAsODC Method
Saves the ODBC connection as a Microsoft Office Data Connection file.
Version Information
Version Added: Excel
Syntax
expression.SaveAsODC(ODCFileName, Description, Keywords)
expression A variable that represents an ODBCConnection object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| ODCFileName | Required | String | Location to save the file. |
| Description | Optional | Variant | Description that will be saved in the file. |
| Keywords | Optional | Variant | Space-separated keywords that can be used to search for this file. |
Return Value
Nothing
Example
The following example saves the connection as an ODC file titled "ODCFile". This example assumes an ODBC connection exists on the active worksheet.
| Visual Basic for Applications |
|---|
|