SaveAsODC 方法 (Excel)QueryTable.SaveAsODC method (Excel)

将数据透视表缓存源保存为 Microsoft Office 数据连接文件。Saves the QueryTable cache source as a Microsoft Office Data Connection file.

语法Syntax

表达式SaveAsODC(ODCFileNameDescription关键字)expression.SaveAsODC (ODCFileName, Description, Keywords)

_表达式_一个代表查询表对象**** 的变量。expression A variable that represents a QueryTable object.

参数Parameters

名称Name 必需/可选Required/Optional 数据类型Data type 说明Description
ODCFileNameODCFileName 必需Required 字符串String 保存文件的位置。Location to save the file.
DescriptionDescription 可选Optional VariantVariant 将保存在文件中的说明。Description that will be saved in the file.
KeywordsKeywords 可选Optional VariantVariant 可用于搜索该文件的以空格分隔的关键字。Space-separated keywords that can be used to search for this file.

支持和反馈Support and feedback

有关于 Office VBA 或本文档的疑问或反馈?Have questions or feedback about Office VBA or this documentation? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.