OLEDBConnection.SaveAsODC (Excel)

Saves the OLE DB connection as a Microsoft Office Data Connection file.

SaveAsODC (ODCFileName, Description, Keywords)

Dim strODCFileName As String: strODCFileName = 
ActiveWorkbook.Connections(1).OLEDBConnection.SaveAsODC ODCFileName:=strODCFileName

Arguments

The following argument is required

ODCFileName (String) - Location to save the file.

Optional arguments

The following arguments are optional

Description (String) - Description that will be saved in the file.

Keywords (String) - Space-separated keywords that can be used to search for this file.