Hi David,
Thanks. Actually, that's where I picked up the idea. 🙂
I've examined the log file after fixing the flaw in the generated ODS path statement. There's a couple of WARNINGs I had to contend with:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
NOTE: The infile "C:\Windows\Resources\Themes\aero.theme" is:
File Name=C:\Windows\Resources\Themes\aero.theme,
RECFM=V,LRECL=256
NOTE: 65 records were read from the infile "C:\Windows\Resources\Themes\aero.theme".
WARNING: Apparent invocation of macro SYSTEMROOT not resolved.
...
NOTE: Overwriting existing template/link: Styles.Aero
NOTE: STYLE 'Styles.Aero' has been saved to: SASUSER.TEMPLAT
...
6493 ods tagsets.ExcelXP path="&MYDIR" file='output.xml' style=styles.aero;
WARNING: Could not locate style reference 'default.theme("CSS")'.
...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I tried to edit the generated 'aero.tpl' file and removed lines/paths that contain the keyword 'SYSTEMROOT'. I then included a proc template statement to include this edited *.tpl file. The first WARNING disappeared, but the second one persists.
Do I need an updated ExcelXP tagset file? The one I used was released June 2006.
Thanks in advance for any ideas or help.
Regards, Audi