Data provider types: Essbase
HypDeleteCalc() deletes a calculation script from an Essbase server.
HypDeleteCalc (vtSheetName, vtApplicationName, vtDatabaseName, vtCalcScript)
ByVal vtSheetName As Variant
ByVal vtApplicationName As Variant
ByVal vtDatabaseName As Variant
ByVal vtCalcScript As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtApplicationName: The name of the application name that contains the calculation script
vtDatabaseName: The name of the database that contains the calculation script
vtCalcScript: The name of the calculation script to be deleted
Returns 0 if successful; otherwise, returns the appropriate error code.
Declare Function HypDeleteCalc Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtApplicationName As Variant, ByVal vtDatabaseName As Variant, ByVal vtCalcScript As Variant) As Long Sub Example_HypDeleteCalc Dim X as Long X = HypDeleteCalc (Empty,"Sample","Basic","CalcYear") End Sub