Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Doing XSLT through VB Script

0 views
Skip to first unread message

Diptorup

unread,
May 6, 2009, 11:17:01 PM5/6/09
to
Hi,

I primarilly work on Hyperion Interactive Reporting suite (not sure if you
any of you are aware of it). Hyperion Interactive Reports are primarilly
built using JavaScript having a native Object Model. They also support OLE
Automation similar to Activex using which we can build Office
documents/spreadsheets etc by utilising the Office Object Model.

In a recent project of mine I was working on building a Word Doc from
scratch using an XML based approach.

The idea being I would generate the XML and the XSL files from Hyperion
using the Windows FileScriptingObject (againt using Hyperion's OLE
automation) and then combine these files using MS Word through VB.

I wanted to know if the Word Object model allows programatically doing XSLT.
I do see an object called XMLTransform (still exploring). If someone could
provide some insight would be very helpful.

Pardon me if I have been too cryptic/verbose.

Dr. Eckehard Pfeifer

unread,
May 7, 2009, 3:12:31 AM5/7/09
to
Hi, the Application.Documents.Open method has a parameter which can give the
transformation to use to transform the opended Xml-data file and thus to get
a Word 2003 ML document.
Another way is to use the msxml5.dll (the transformnode method of a
XmlDomDocument) and do the things in JavaScript.

--
MfG EP
Entwicklung - Beratung - Training (www.dr-e-pfeifer.net)
XL-Maxibuch (ISBN: 3-86645-231-4)
Microsoft Office 2007-Programmierung (ISBN 3-86645-415-5)

0 new messages