>I've been using COPY to blah.xls TYPE XLS for years, but just found out that using TYPE XL5 formats dates properly. The problem with XL5 is that my column widths are all lost and each is the exact same default width. Any ideas how to solve this?
I would use Automation to change the column widths, after creating the Excel file.
Doing everything with Automation (copying one cell at a time) would be much slower, so using COPY TO ... XL5 does make sense.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)