PreviousNext
Help > FAQ and miscellaneous > Cancelling an EXCEL sheet
Cancelling an EXCEL sheet

 Use XLDELSHEET command to cancel an Excel sheet. In this case, the system issues a confirmation window.

OK can be set as default answer.

 

A trick to avoid some Excel windows is to set "DisplayAlerts" property to "False".

 

Example:

 

Using LNCCMD with XLSETPROP command :

 

 CHGVAR VAR(&CMD) VALUE(XLSETPROP)

 CHGVAR VAR(&PARM1) VALUE('displayalerts')

 CHGVAR VAR(PARM2) VALUE(false)