Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. fboehlandt

    Load method with file URL file location reference

    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...
  2. fboehlandt

    VBScript to convert XML to Excel

    For completion sake, the entire code: Sub XMLtoXLS() Dim oXML, oXSL, filestr, Targetfolder Dim sHTML, fso, FileName, MyFile Dim xlApp, xlWbk Const ForWriting = 2 Const TristateTrue = -1 Const xlNormal = 51 'Load the XML and the XSL (the stylesheet). Set oXML =...
  3. fboehlandt

    VBScript to convert XML to Excel

    Well I'll be...! That's easy enough indeed. I did say I didn't know VBScript though. Thanks for your input, this worked for me
  4. fboehlandt

    VBScript to convert XML to Excel

    This is how far I can get from your input: I can create the html-file and write something to it. However, I don't know how to write the contents from the XML file to the newly created HTML using the style sheet. Sub XMLtoXLS() Const ForWriting = 2 Const TristateTrue = -1 Dim fso, MyFile...
  5. fboehlandt

    VBScript to convert XML to Excel

    Hello everyone I need to transform an XML file to Excel. The style sheet (XSL) should be applied on import. There appears to be an acknowledged bug: http://support.microsoft.com/kb/307230/en-US The workaroudn involves converting XML to HTML first, then to Excel-format. The script is in VBA...

Part and Inventory Search

Back
Top