VBA Return Values

The Essbase Visual Basic functions and the extended spreadsheet macros return values indicating the success or failure of the function. The functions return these types of values:

Table 23 lists the return values for local problems, represented by negative numbers.

Table 23. VBA Return Values

Return ValueMeaning

The function ran successfully.

-1

Initialization error. Call Technical Support.

-2

Termination error. Call Technical Support.

-3

Initialization error. Call Technical Support.

-4

The spreadsheet is not yet connected to the server.

-6

The spreadsheet is unstable. Call Technical Support.

-7

The spreadsheet is unstable. Call Technical Support.

-8

No FlashBack information exists.

-9

The operation is canceled.

-12

FlashBack is not enabled.

-13

Not enough memory resources are available.

-14

The Essbase dialog box cannot be displayed. Call Technical Support.

-15

The function contains an invalid parameter.

-16

A calculation is in progress.

-17

A SQL Drill-Through operation is in progress.

-18

The operation is not allowed because the spreadsheet is in formula-preserve mode.

-19

The operation cannot take place on the specified sheet.

-20

The current sheet cannot be determined.

-21

You did not specify a spreadsheet name and no sheet is active.

-22

You cannot cancel a calculation because no calculation is running.

-23

The selection parameter is invalid.

-25

The cascade list file cannot be created, or you are attempting to cascade while the spreadsheet is embedded in another document.

-26

You cannot run the spreadsheet macros due to a licensing constraint.

-27

You cannot run the spreadsheet macros which update the database due to a licensing constraint.

-28

You cannot update the database because the database license is read-only.

-29

You are not licensed to use SQL Drill-Through.

-30

The menu is removed.

-31

The menu is added.