Hi Hans-Otto,
Thanks for your reply and the routine. Actually I currently don't have a requirement - I have used Excel automation/COPY TO ..XL5 as required.
I was hinting to John that the community would love to see his FRX2WORD extend to encompass Excel. It could then be used in a generic export routine with no additional processing added to exixting reports.
Thanks
>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