How to apply XSL automatically

I need to open an XML data file in word2003, then apply an
XSL to the XML, then save as a .Doc , How can this be done
automatically using VBA? Where should I keep the code, in
a template maybe?
Thanks!
CD

Lars-Eric
Thu Nov 06 14:23:28 CST 2003

The way we have solved that problem is by creating a solution (manifest
file) with only XSL files for a specific NameSpace. Attach the solution to
Word and that's it.

The requirement is that your XML file has a default NameSpace. When you open
the XML file in Word it recognize that you have a solution for that
NameSpace and will automatically apply the first transform you have in the
solution for that NameSpace. Each transform is then listed in the taskpane
so by just clicking on the names of the transforms you can instantly change
between different views of the same XML data. VBA is not involved at all.

Regards,
Lars-Eric

"CD" <anonymous@discussions.microsoft.com> skrev i meddelandet
news:066a01c3a47e$add15e80$a001280a@phx.gbl...
> I need to open an XML data file in word2003, then apply an
> XSL to the XML, then save as a .Doc , How can this be done
> automatically using VBA? Where should I keep the code, in
> a template maybe?
> Thanks!
> CD
>
>
>
>

anonymous
Fri Nov 07 09:21:13 CST 2003

Thank you for the reply. It sounds a very good approach. I am working on the manifest file now. Would you like to share some of the code in your manifest file.
Thanks again!
CD

Lars-Eric
Fri Nov 07 11:05:47 CST 2003

I have the files at my job so I can't show you any code before next week.

Regards,
Lars-Eric

"CD" <anonymous@discussions.microsoft.com> skrev i meddelandet
news:7E84195A-61A5-4430-A091-8925E8F3D643@microsoft.com...
> Thank you for the reply. It sounds a very good approach. I am working on
the manifest file now. Would you like to share some of the code in your
manifest file.
> Thanks again!
> CD

anonymous
Fri Nov 07 13:51:05 CST 2003

No Problem, I can wait. Thank you very very much! Have a nice weekend!

Lars-Eric
Mon Nov 10 01:42:09 CST 2003

This is the Mainfest file I use as a template for transform solutions. It
contains two transforms and one schema
--------------------------------
<manifest
xmlns="http://schemas.microsoft.com/office/xmlexpansionpacks/2003">
<version>1.0</version>
<updateFrequency>20160</updateFrequency>

<!--<uri>"http://schemas.microsoft.com/office/xmlexpansionpacks/2003/mostl"<
/uri>-->
<uri>www.signon.se/rfv/xsltest</uri>
<solution>
<solutionID>TransformTest1-XSL</solutionID>
<type>transform</type>
<alias>Transform for www.signon.se/rfv/xsltest namespace</alias>
<context>http://schemas.microsoft.com/office/word/2003/wordml</context>
<file>
<type>primaryTransform</type>
<version>1.0</version>
<filePath>MailTrans1.xsl</filePath>
</file>
</solution>
<solution>
<solutionID>TransformTest2-XSL</solutionID>
<type>transform</type>
<alias>Transform 2 for www.signon.se/rfv/xsltest namespace</alias>
<context>http://schemas.microsoft.com/office/word/2003/wordml</context>
<file>
<type>primaryTransform</type>
<version>1.0</version>
<filePath>MailTrans2.xsl</filePath>
</file>
</solution>
<solution>
<solutionID>TransformTest-1ED7D88393F5</solutionID>
<type>schema</type>
<alias>Transform Test</alias>
<file>
<type>schema</type>
<version>1.0</version>
<filePath>TestTransform.xsd</filePath>
</file>
</solution>
</manifest>
------------------------

Regards,
Lars-Eric

"CD" <anonymous@discussions.microsoft.com> wrote in message
news:8958741E-840A-42D8-8FDD-CD53D1F589F2@microsoft.com...
> No Problem, I can wait. Thank you very very much! Have a nice weekend!
>

anonymous
Mon Nov 10 08:41:05 CST 2003

Thank you very much!