Re: Re: Producing Excel spreadsheet from XML data

[MacEwan, James]

> Thanks to all for your comments.  I have summarized the responses (so far)
> below:
>

Thanks for giving us this summary.  Much apprciated.

>
> My solution will probably be as follows:  (1) no XSL transformation occurs
> on Unix (2) FTP the XML document to NT (3) write a VB program that
traverses
> the XML and writes interesting bits of data into the right spots into the
> Excel (COM that calls MSXML3 and Excel's automation interfaces).
>
Sounds like a good approach.  Whether you have a separate VB program or use
VBS from within Excel won't be much different in practice, I believe.

Cheers,

Tom P


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list