[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
excel domdocument
----- 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

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.