Share via


QueryTable.SaveAsODC Method

Excel Developer Reference

Saves the QueryTable cache source as an Microsoft Office Data Connection file.

Syntax

expression.SaveAsODC(ODCFileName, Description, Keywords)

expression   A variable that represents a QueryTable 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.

See Also