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