Copy the current sheet into the same workbook. The copy appears after the copied sheet.
The copy then becomes the current sheet.
Syntax
|
CHGVAR |
VAR(&CMD) VALUE('XLCOPYSH') |
|
CHGVAR |
VAR(&PARM1) VALUE(' ') |
|
CHGVAR |
VAR(&PARM2) VALUE(' ') |
|
CALL |
PGM(LNCCMD) PARM(&HANDLE &CMD &OPT &PARM1 + &PARM2 &RESULT) |
Example
CHGVAR VAR(&CMD) VALUE('XLOPENFILE')
CHGVAR VAR(&PARM1) VALUE('FILE="C:\TEMP\CLASSEUR1.XLSX"')
CHGVAR VAR(&PARM2) VALUE('VISIBLE')
CALL PGM(LNCCMD) PARM(&HANDLE &CMD &OPT &PARM1 +
&PARM2 &RESULT)
CHGVAR VAR(&CMD) VALUE('XLCOPYSH')
CHGVAR VAR(&PARM1) VALUE(' ')
CHGVAR VAR(&PARM2) VALUE(' ')
CALL PGM(LNCCMD) PARM(&HANDLE &CMD &OPT &PARM1 +
&PARM2 &RESULT)