Hi Ashley,
>Using COPY TO .. XL5 has its limitations: formatted, calculated fields which would need to be stored to a cursor mirroring the output. It also results in ugly output.
I agree and for that reason I made up a rather simple (and limited) function, called
maketable(<some paramters>)
(see message #
690813). This function converts a cursor or a table into an Excel sheet via automation, if you provide the column header lines via a different header.xls, giving width and orientation. Fonts etc are fixed, but can be easily parameterized as well with little additional work.
Rather simple, but it works for me - maybe it is a starter for you.
Hans