|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Needing to use XML with Excel
Hi everbody, this is my first time in these list.
I' don't know if my question is pertinent to this list, if not, sorry.
Well I have an XSL that compares data from two XML files and I' trying to
display the results in MsExcel.
the usual macro that I work is:
----------------------------------------------------------------------------
---------
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
---------------------------------------------------------------------------
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
Vitoria/ES
Brasil
|
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
|

Cart








