QueryTable.SaveAsODC method (Excel)
Saves the QueryTable cache source as a Microsoft Office Data Connection file.
expression.SaveAsODC (ODCFileName, Description, Keywords)
expression A variable that represents a QueryTable object.
| 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. |
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.