EssCascade

Description

Cascades on the selection, generating multiple worksheets.

Syntax

EssCascade([workbookName]sheetName, range, selection, path, prefix, suffix, level, open, copy, overwrite, listFile)

Where [workbookName]sheetName is the text name of the source workbook and worksheet.

range is a reference to the area of data to be retrieved.

selection is a reference to the selected members.

path is a text item that indicates the destination of the worksheets generated.

prefix is a text item placed before the names of the generated worksheets.

suffix is a text item placed after the names of the generated worksheets.

level is a number that indicates the granularity of the cascade. The level numbers and associated actions are shown in Table 24.

Table 24. Level Numbers and Actions

Level	Action
1	Cascade to next level (children).
2	Cascade to all levels (descendants).
3	Cascade to the lowest level(bottom).
4	Cascade using siblings.
5	Cascade to same level.
6	Cascade to same generation.
7	Cascade to calculation script.

open is a logical value that determines whether the generated worksheets should be opened after creation. A value of TRUE indicates that the spreadsheet should be opened; FALSE indicates that the spreadsheet should not be opened.

copy is a logical value that determines whether the formatting information of the parent spreadsheet is used in the creation of the new spreadsheet. A value of TRUE indicates that the newly-created spreadsheet inherits the formatting of its parent; FALSE means no formatting is copied.

overwrite is a logical value that determines whether newly-created spreadsheets can overwrite previously saved spreadsheets. A value of TRUE means the user is not prompted when an overwrite occurs; a value of FALSE indicates that the user is given a chance to rename the spreadsheet.

listFile is a logical value that determines whether a report of the cascade is created. A value of TRUE means a listFile is created in the path with the name prefix0suffix.lst.

Example

=EssCascade("[Sample.xls]Sheet1",SAMPLE.XLS!A1:G20,SAMPLE.XLS!B2,
"C:\ESSBASE\CLIENT\SAMPLE",,,1,FALSE,TRUE,FALSE,TRUE)

Notes

The active spreadsheet is used when the sheetName parameter is missing.
The contents of sheetName is used when the range parameter is missing.
The active cell is used when the selection parameter is missing.
The spreadsheet directory is used when the path parameter is missing.
A value of 1 is assumed when the level parameter is missing.
The value FALSE is assumed when open is missing. If too many spreadsheets are opened, Excel can run out of memory, causing unexpected results.
The value TRUE is assumed when the copy parameter is missing.
The value TRUE is assumed when the overwrite parameter is missing.
The value FALSE is assumed when the listFile parameter is missing.