GetNextSheet

Description

Obtains the sheet that is behind the specified sheet in the MDI frame.

Applies to

MDI frame windows

Syntax

mdiframewindow.GetNextSheet ( sheet )

Argument

Description

mdiframewindow

The MDI frame window in which you want the next sheet

sheet

The sheet for which you want the sheet that is behind it


Return value

Window. Returns the sheet that is behind sheet in the MDI frame. If there is no sheet behind sheet, GetNextSheet returns an invalid value. If any argument's value is null, GetNextSheet returns null.

Usage

To cycle through the open sheets in a frame, use GetFirstSheet to get the front sheet and GetNextSheet one or more times to get the rest of the sheets. Test each return value with IsValid to see if you have reached the last sheet. Do not use GetFirstSheet and GetNextSheet in combination with GetActiveSheet.

Did GetNextSheet return a valid window?

Use the IsValid function to find out if GetNextSheet returned a valid window. If there is no sheet behind the one you specified, the return value is not valid.

Examples

The following script for a menu selection loops through the open sheets in front-to-back order and displays the names of the open sheets in the ListBox lb_sheets:

boolean bValid
window wSheet
 
lb_sheets.Reset()
wSheet = ParentWindow.GetFirstSheet()
IF IsValid(wSheet) THEN
   lb_sheets.AddItem(wSheet.Title)
   DO
   wSheet = ParentWindow.GetNextSheet(wSheet)
   bValid = IsValid (wSheet)
   IF bValid THEN lb_sheets.AddItem(wSheet.Title)
   LOOP WHILE bValid
END IF

See also

GetFirstSheet

IsValid