Subject: [xsl] Needing to use XML with Excel From: "nellsousa" <nellsousa@xxxxxxxxxxxx> Date: Sun, 8 Jan 2006 21:14:10 -0200 |
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 _______________________________________________________ Yahoo! doce lar. Faga do Yahoo! sua homepage. http://br.yahoo.com/homepageset.html
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] include, import trouble, Florent Georges | Thread | Re: [xsl] Needing to use XML with , Joe Fawcett |
RE: [xsl] <xsl:value-of...> not get, Florent Georges | Date | RE: [xsl] include, import trouble, Michael Kay |
Month |