Hi all, I am trying to create a XML file ... however, I wanted to add another processing instruction in the XML file so that the xml file can display the way I wanted. But I can't seem to be able to add the XSL processing instruction into my XML file. My code to create XML file is follow:-

===============================

 .....

'Create the xml processing instruction.
    Set objPI = objDom.createProcessingInstruction("xml", "version='1.0'")

        'This is waht I wish to appear in the xml file.
 -------> Set objPI2 = objDom.createProcessingInstruction("xml-stylesheet", "type='text/xsl'", "href='simple.xsl'")


    'Append the processing instruction to th ' e XML document.
    objDom.insertBefore objPI, objDom.childNodes(0)

        'Append the XSL PI after the XML PI
        -----> objDom.insertAfter objPI2, objPI
================================================== =

Is that doable? Or it's impossible to create an XML with 2 PIs???

The first one isn't a processing instruction, it's the xml declaration or prolog although you can create it using the method you are employing.
Yes, you can create the second one but you just pass it one long string:
Joe (MVP - xml)

Hi Joe, the XML file came out put the second declaration first ... how can I put it to display the first prolog, then second?? And I realized it doesn't has insertAfter methods :(
================================================== =============

'Create the xml processing instruction.
    Set objPI = objDom.createProcessingInstruction("xml", "version='1.0'")
    Set objPI2 = objDom.createProcessingInstruction("xml-stylesheet", "type='text/xsl' href='simple.xsl'")

    'Append the processing instruction to the XML document.
    objDom.insertBefore objPI, objDom.childNodes(0)
     objDom.insertBefore objPI2, objDom.childNodes(0)

appendChild adds the node to the end of the current child nodes.

Joe (MVP - xml)

Hi Joe, sorry for the late reply. I was moving to a new place last week. The 'appendChild' properties add the second declaration(xsl) AFTER all the nodes ... :(

Code:
=================================
 Set objPI = objDom.createProcessingInstruction("xml", "version='1.0'")
     Set objPI2 = objDom.createProcessingInstruction("xml-stylesheet", "type='text/xsl' href='simple.xsl'")

    'Append the processing instruction to the XML document.
     objDom.insertBefore objPI, objDom.childNodes(0)
     objDom.appendChild objPI2

=================================

Output:
=================================
<?xml version="1.0"?>
<Name>Mike</Name>
<?xml-stylesheet type='text/xsl' href='simple.xsl'?>
=================================

Well call it earlier...

--

Joe

Hey guys this is the way to do it
It has been broken up to make it self explanatory..otherwise
a few lines are dovetailed in my implementation
*****************************************

        Dim transform As XslTransform = New XslTransform()
        transform.Load("ABCD.xsl")
        pRateResponseXML = New XmlDocument()
        pRateResponseXML.load("EFG.xml")
        Dim xReader As XmlReader = transform.Transform(responseXML, Nothing)
        pRateResponseXML.Load(xReader)
        transform = Nothing
        SetRatePackageResponse = True