Share via


PivotCache.SaveAsODC Method

Excel Developer Reference

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

Syntax

expression.SaveAsODC(ODCFileName, Description, Keywords)

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

Example

The following example saves the cache source as an ODC file titled "ODCFile". This example assumes a PivotTable cache exists on the active worksheet.

Visual Basic for Applications
  Sub UseSaveAsODC()
Application.ActiveWorkbook.PivotCaches.Item(1).<strong>SaveAsODC</strong> ("ODCFile")

End Sub

See Also