on 08-08-2018 1:30 PM
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
Try instead of:
FPMXLClient.ProtectSheet_ProtectContents
use:
api.ProtectSheet_ProtectContents
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.