cancel
Showing results for 
Search instead for 
Did you mean: 

VB is not working in AO 2.6 EPM

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

Try instead of:

FPMXLClient.ProtectSheet_ProtectContents

use:

api.ProtectSheet_ProtectContents