fboehlandt Posted May 20, 2014 Share Posted May 20, 2014 (edited) 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: oXSL.Load "http://srv001234.internal.com/somedirectory/XSLtheme.xsl" does not work, presumably since the load method does not work with URL. Do I have to access the file via browser and save locally or is there a quicker method? And if so, what would I have to do to dave the file to the local directory? Many thanks in advance Edited May 20, 2014 by fboehlandt Link to comment Share on other sites More sharing options...
justsomeguy Posted May 20, 2014 Share Posted May 20, 2014 It at least looks like later versions of MSXML support URLs. I can't even find API documentation for version 1.http://msdn.microsoft.com/en-us/library/ms762722(v=vs.85).aspx Link to comment Share on other sites More sharing options...
php freelancer Posted June 25, 2014 Share Posted June 25, 2014 Thanks. My issue resolved as well with this. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now