Bonjour,
I get into Focus/MVS : version FOCUS 7.6.11 and try to build Compound Reports (I could not reach FORMAT EXL2K OPEN/CLOSE with Prior Focus Versions)
I certainly miss a point because the Hold file that Focus creates does not work with Excel 2007. ( Impossible de lire le fichier)

This Good Old Focus creates me, exactly what I want ( A single File with two Sheets)
But there must be something wrong somewhere ( perhaps in the transcoding EBCDIC -> ASCII)
The X'15' before --====Boundary==== puzzles me :
BROWSE xx.xxxxx.xxxxxx.EX1
Command ===>
.--====Boundary====
1667777C9A9889A7777
500EEEE26454198EEEE

Thanks for Help
Focusely and Cordially

The Focus Fex is taken out of documentation :

SET PAGE-NUM=OFF
TABLE FILE CAR
HEADING
"Sales Report"
" "
SUM SALES
BY COUNTRY
ON TABLE SET STYLE *
type=report, titletext='Sales Rpt', $
type=heading, size=18, $
ENDSTYLE
ON TABLE HOLD AS EX1 FORMAT EXL2K OPEN
END
TABLE FILE CAR
HEADING
"Inventory Report"
" "
SUM RC
BY COUNTRY
ON TABLE SET STYLE *
type=report, titletext='Inv. Rpt', $
type=heading, size=18, $
ENDSTYLE
ON TABLE HOLD FORMAT EXL2K CLOSE
END

And the EX1 Held file begins as follow (And is contains everything to m

MIME-Version: 1.0
X-Document-Type: Workbook
Content-Type: multipart/related; boundary="====Boundary===="
--====Boundary====
Content-Location: file:///C:/EX1.XHT
Content-Transfer-Encoding: 8bit
Content-Type: text/html; charset="windows-1252"

xmlns="urn:schemas-microsoft-comfficeffice"
xmlns:x="urn:schemas-microsoft-comffice:excel"
xmlns="http://www.w3.org/TR/REC-html40">








Sales Rpt



Inv. Rpt







.--====Boundary====
Content-Location: file:///C:/IBIT0001.xht
Content-Transfer-Encoding: 8bit
Content-Type: text/html; charset="windows-1252"
.
xmlns="urn:schemas-microsoft-comfficeffice"
xmlns:x="urn:schemas-microsoft-comffice:excel"
xmlns="http://www.w3.org/TR/REC-html40">