Application.TransformXML Method (Access)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Applies an Extensible Stylesheet Language (XSL) stylesheet to an XML data file and writes the resulting XML to an XML data file.

expression .TransformXML(DataSource, TransformSource, OutputTarget, WellFormedXMLOutput, ScriptOption)

expression A variable that represents an Application object.

Parameters

Name

Required/Optional

Data Type

Description

DataSource

Required

String

The name and path of the XML file to import.

TransformSource

Required

String

The name and path to the XSL file to apply to the XML data file.

OutputTarget

Required

String

The file name and path for the resulting XML data file after applying the XSL file.

WellFormedXMLOutput

Optional

Boolean

Setting this argument to True will create a well-formed XML file. Setting this argument to False will encode the resulting XML file in UTF-16 format. The default value is False.

ScriptOption

Optional

AcTransformXMLScriptOption

A AcTransformXMLScriptOption constant that specifies the action taken if the XSL file contains scripting code. The default value is acPromptScript.

Return Value

Nothing

Setting the WellFormedXMLOutput argument to True will result in a run-time error if the XSL file that you apply does not result in well-formed XML.

Show: