Description
Gets Essbase currency information from the specified spreadsheet.
Syntax
EssGetCurrency([workbookName]sheetName)
Where [workbookName]sheetName is the text name of the workbook and worksheet where the currency information is obtained.
Example
=EssGetCurrency("[Sample.xls]Sheet1")Notes:
The active spreadsheet is used when the sheetName parameter is missing.
EssGetCurrency returns the active currency setting. For example, if the active currency setting is Canadian dollars, Essbase returns (CN$).