TransformXML Method

Microsoft Access Visual Basic

Show All Show All

TransformXML Method

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    Required. An expression that returns an Application object.

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. Specifies the action taken if the XSL file contains scripting code.

AcTransformXMLScriptOption can be one of the following AcTransformXMLScriptOption constants
acDisableScript The script is disabled.
acEnableScript The script is enabled.
acPromptScript default The user is prompted to disable or enable the script.

Remarks

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.