[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
[Recent Entries]
[Reply To This Message]
Re: Needing to use XML with Excel
Subject: Re: 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: Needing to use XML with Excel
Hi 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
Nel
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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format
RSS 2.0 |
|
Atom 0.3 |
|
|