Query to Excel again!

Hi to all
I'm still struggling with exporting a query to excel.
Which is fastest way?
I can't use loading the query to a screen table and use then tabletoxls since this procedure runs under an automatic Procedure (earlier threadexecute) and i was not able to open a window under these circumstances.
Thanks for all the help
Swissstephan

Quote
Swissstephan
Hi to all
I'm still struggling with exporting a query to excel.
Which is fastest way?
I can't use loading the query to a screen table and use then tabletoxls since this procedure runs under an automatic Procedure (earlier threadexecute) and i was not able to open a window under these circumstances.
Thanks for all the help
Swissstephan

Try this method:-
1) Create a report based on this query ( let's called it RPT1 )
2) Use the following commands to call the report ( have a button that called this code )
iPreview(iGenericXLS)
iPrintReport(RPT1)
IF YesNo("Data exported to RPT1.xls","","Open the file with Excel?") THEN
ShellExecute(fShortPath("RPT1.xls"))
END

Regards,

PETER ZHOU

HI Peter
Thanks for your ideas!
I can use the starting of Excel on another place in my project, but I'mno shure if your ideas help me in my actual problem.
How do I build a report from a query with 200 fields?
Thanks again for your help

It must be one XLS file or CSV is enough?
If CSV is ok to you, why don't you try ARRAYTOCSV.
I never used it but it is supposed to work in WX XII.