Hi,

I have created a .fex where I have 4 tables and I want to output the results as 1 single excel file instead of having to save them separately. Is this possible? If so, can someone post the syntax?

If you're using OFFICE 2003 (XP), and version 5.3 or above, you can do "compound" reports.
At the end of the first report you do
ON TABLE PCHOLD FORMAT EXL2K OPEN

If you want all of the results on the same tab, you add
ON TABLE PCHOLD FORMAT EXL2K NOBREAK
to each subsequent report.

On the last report you do
ON TABLE PCHOLD FORMAT EXL2K CLOSE

If you want each report to show on it's own tab in the Excel file, just do the OPEN on the first report, the CLOSE on the last report and
ON TABLE PCHOLD FORMAT EXL2K
on each report in between.

Deb

TABLE FILE ..
ON TABLE HOLD AS HOLD1

:


ON TABLE HOLD AS HOLD4
END
-RUN
DYNAM CONCAT DD HOLD1 HOLD2 HOLD3 HOLD4
TABLE FILE HOLD1
:
ON TABLE HOLD AS ... FORMAT EXL2K

WF Doc. Ref.:

Creating Excel Compound Reports:
http://documentation.informationbuilders.com/masterinde...f713crlang/dis12.htm

Regards,
Mikel

Worked Great, thanks for the help everyone.