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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by fboehlandt

  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...
See more

Part and Inventory Search

Back
Top