ODBCConnection.SaveAsODC Method (Excel)
Saves the ODBC connection as a Microsoft Office Data Connection file.
Version Information
Version Added: Excel 2007
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.
Sub UseSaveAsODC()
Application.ActiveWorkbook.ODBCConnection.SaveAsODC ("ODCFile")
End Sub