After the functions are declared at the top of the module, you can call them in your VBA code. When you call a function, you tell it to perform its intended action and return a value. You can test the returned value to see if the function ran successfully.
This example shows the syntax for EssVCalculate.
EssVCalculate(sheetName, calcScript, synchronous)
When you call a function, observe these guidelines:
Enter a value for every parameter. All parameters are required. If you do not want to specify a value for a parameter, enter Null or Empty so that Essbase uses the default value for that parameter.
Assign the function to a variable. After the function runs, the variable stores the return value, which indicates the success or failure of the function.
CalcRes=EssVCalculate("[Book.xls]Sheet", "[Default]", False)