_QueryTable.SaveAsODC Method

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub SaveAsODC ( _
    ODCFileName As String, _
    Description As Object, _
    Keywords As Object _
)
'Usage
Dim instance As _QueryTable
Dim ODCFileName As String
Dim Description As Object
Dim Keywords As Object

instance.SaveAsODC(ODCFileName, Description, _
    Keywords)
void SaveAsODC(
    string ODCFileName,
    Object Description,
    Object Keywords
)

Parameters

  • ODCFileName
    Type: System.String

    Required String. Location to which the file is saved.

  • Description
    Type: System.Object

    Optional Object. Description that will be saved in the file.

  • Keywords
    Type: System.Object

    Optional Object. Space-separated keywords that can be used to search for this file.

See Also

Reference

_QueryTable Interface

_QueryTable Members

Microsoft.Office.Interop.Excel Namespace