Tramsform XML using XSLT, This works for me

  • I have seen a lot about this and I though I would share the fruits of my effort.

    I used to process XML with a XSLT style sheet by using the following command:
    Workbooks.OpenXML Filename:="Path_to_XML_file", Stylesheets:=Array(1)

    This used to work until I had Excel upgraded from Excel 2003 to Excel 2010. However, Excel 2010 by default does not allow the stylesheet to contain scripting or references to additional stylesheets. After much searching on the web I found some documentation by Microsoft (…op/ms765520(v=vs.85).aspx) and (…op/ms766487(v=vs.85).aspx)

    Then I came up with the following:

    sorry, I misspelled the word "transform" in the title but the "Edit Post" did not let me change it.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!