Some users of newer versions of Office will, by default, have moderate to severe difficulty when trying to open Excel version 5 ("TYPE XL5") workbook files i.e.
http://www.pcworld.com/article/3016278/software/print-preview-and-open-old-office-files.html . One client started getting a lot of support calls when users started upgrading to Office 2013 and they wanted me to change their "Save to Excel" function. The new process is:
- save the output as a FOX2X table
- using automation, open it in the customer's Excel (any version of Excel can open a FOX2X DBF file), then save as .XLSX
>Hi,
>
>you can specify the fields to export:
>
>
>COPY TO FileName [FIELDS FieldList | FIELDS LIKE Skeleton | FIELDS EXCEPT Skeleton] type XL5
>
>
>
https://msdn.microsoft.com/en-us/library/aa977446(v=vs.71).aspx>
>>Hi All,
>>
>>Is there a way to programmatically re-order the columns in a table? I want to export the table to an Excel sheet in a user-defined order.
>>Thanks.
>>
>>Luke
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up