ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XML exports and style sheets (https://www.excelbanter.com/excel-programming/308014-xml-exports-style-sheets.html)

No Name

XML exports and style sheets
 
Can I make Excel 2003 add a line of the form:
<?xml-stylesheet type="text/xsl" href="my style.xsl"?
to the file it produces when exporting XML data?

Ideally, this could be specified on each XML map
independently.

Stephen Bullen[_3_]

XML exports and style sheets
 
Can I make Excel 2003 add a line of the form:
<?xml-stylesheet type="text/xsl" href="my style.xsl"?
to the file it produces when exporting XML data?

Ideally, this could be specified on each XML map
independently.


Not directly, but you could use the _AfterXMLExport event to
post-process the file, adding that line.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie




All times are GMT +1. The time now is 10:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com