Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Save to XLS file name
Message
 
 
To
22/12/2012 18:47:43
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01560484
Message ID:
01560486
Views:
59
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform