次の方法で共有


Application.WorkbookAfterXmlExport Event (Excel)

Occurs after Microsoft Excel saves or exports XML data from the specified workbook.

Syntax

expression .WorkbookAfterXmlExport(Wb, Map, Url, Result)

expression A variable that represents an Application object.

Parameters

Name

Required/Optional

Data Type

Description

Wb

Required

Workbook

The target workbook.

Map

Required

XmlMap

The XML map that was used to save or export data.

Url

Required

String

The location of the XML file that was exported.

Result

Required

XlXmlExportResult

Indicates the results of the save or export operation.

Return Value

Nothing

Remarks

XlXmlExportResult can be one of the following XlXmlExportResult constants

xlXmlExportSuccess . The XML data file was successfully exported.

xlXmlExportValidationFailed. The contents of the XML data file do not match the specified schema map.

Use the AfterXmlExport event if you want to perform an operation after XML data has been exported from a particular workbook.

See Also

Concepts

Workbook Object

Workbook Object Members

Application Object

Application Object Members