Hello everyone
I have some code that transforms and XML to HTML using a style sheet. The transformation below works fine:
'Load the XML and the XSL (the stylesheet)
Set oXML = CreateObject("MSXML.DOMDocument")Set oXSL = CreateObject("MSXML.DOMDocument")oXML.Load "D:some directoryXMLfile.xml"oXSL.Load "D:some directoryXSLtheme.xsl" 'Transform the XML using the stylesheet
sHTML = oXML.transformNode(oXSL)
However, the XLS file is usually referenced as a URL rather than a Windows file path (the XLS file is lolcated on a different server). Changing the relevant line to:
oXS