[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
----- Original Message ----- From: "nellsousa" <nellsousa@xxxxxxxxxxxx>
To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
Sent: Sunday, January 08, 2006 11:14 PM
Subject: [xsl] Needing to use XML with Excel
I think your question might be relevant if I understood it.
Rather than show the VBA code you are using to transform can you show what you mean with "insert the file orders.xml..."?
Perhaps show all or the necessary part of the transform and a sample of the XML.
Regards
Joe
Re: [xsl] Needing to use XML with Excel
Subject: Re: [xsl] Needing to use XML with Excel From: "Joe Fawcett" <joefawcett@xxxxxxxxxxx> Date: Mon, 9 Jan 2006 07:48:14 -0000 |
----- Original Message ----- From: "nellsousa" <nellsousa@xxxxxxxxxxxx>
To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
Sent: Sunday, January 08, 2006 11:14 PM
Subject: [xsl] Needing to use XML with Excel
NelHi everbody, this is my first time in these forum. I'm not sure if this is a pertinent question to this group, if not, sorry.
Well I have an XSL that compares data from two XML files and I' trying to display results in MsExcel. The usual macro that I'm working is: VBA:
Sub Macro_libr() 'Load the XML and the XSL (the stylesheet). Dim oXML As Object, oXSL As Object Set oXML =3D CreateObject("MSXML.DOMDocument") Set oXSL =3D CreateObject("MSXML.DOMDocument") oXML.Load "c:\library.xml" oXSL.Load "c:\compare_books.xsl"
'Transform the XML using the stylesheet. Dim sHTML As String sHTML =3D oXML.transformNode(oXSL)
'Save the results to an XLS file. Open "c:\BooksToBuy.xls" For Output As #1 Print #1, sHTML Close #1 'Automate Excel to open the XLS file. Dim oApp As Excel.Application Set oApp =3D CreateObject("excel.application") oApp.Visible =3D True oApp.Workbooks.Open "c:\BooksToBuy.xls"
End Sub
My question: when I use just one XML with XSL it works fine, but when I try to insert the file orders.XML that is called into the XSL to do the comparation nothing appears.
Any idea??
Nel Sousa ES/Brasil
I think your question might be relevant if I understood it.
Rather than show the VBA code you are using to transform can you show what you mean with "insert the file orders.xml..."?
Perhaps show all or the necessary part of the transform and a sample of the XML.
Regards
Joe
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Needing to use XML with Exce, nellsousa | Thread | [xsl] Needing to use XML with Excel, nellsousa |
[xsl] How do I do to work with a xs, nellsousa | Date | Re: [xsl] Trouble understanding how, Peter Flynn |
Month |