PivotCache.SaveAsODC Method

  • Article
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