Skip to Content

VB is not working in AO 2.6 EPM

Hello -

we are upgrading the EPM from EPM SP 27 to AO 2.6 and below code is not working.

Dim cofCom As Object

Set cofCom = Application.COMAddIns("SapExcelAddIn").Object

Dim api As Object

Set api = cofCom.GetPlugin("com.sap.epm.FPMXLClient")

Dim SheetProtectionOptions As Long

SheetProtectionOptions = FPMXLClient.ProtectSheet_ProtectContents + FPMXLClient.ProtectSheet_AllowColumnDelete + FPMXLClient.ProtectSheet_AllowColumnInsert

api.SetSheetOption Sheet1, 301, True, "a", SheetProtectionOptions

End Sub



I am getting compiler error " Variable not defined" for FPMXLClient.



Note : FPMXLClient reference is disabled as we are using the AO 2.6 and those are called directly during runtime using the

cofCom.GetPlugin("com.sap.epm.FPMXLClient").



Thanks,


Bharat

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 08, 2018 at 12:41 PM

    Try instead of:

    FPMXLClient.ProtectSheet_ProtectContents

    use:

    api.ProtectSheet_ProtectContents

    Add comment
    10|10000 characters needed characters exceeded