[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Needing to use XML with Excel

Subject: Needing to use XML with Excel
From: "nellsousa" <nellsousa@xxxxxxxxx>
Date: Sun, 8 Jan 2006 22:39:43 -0200
xml from 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

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.