>I want to save a table as XLS. (Excel) With the UT's help I learned to save a variable's contents as a table name, but I am having no success converting the method to saving as XLS.
>What I have so far is below, it just produces a file named filetosave :-(
>
>
>PRIVATE filetosave
>m.FileToSave = CDOW(DATE())
>COPY TO (m.FiletoSave).XLS FOR len(alltrim(indicator)) > 2 TYPE XL5
>
Try
local filetosave
m.FileToSave = forceext(CDOW(DATE()), 'xls')
COPY TO (m.FiletoSave) FOR len(alltrim(indicator)) > 2 TYPE XL5
If it's not broken, fix it until it is.
My Blog