>>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
>
:-) Right away, Ma'am. and Thank you and Merry Christmas
I ain't skeert of nuttin eh?
Yikes! What was that?