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("")

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




Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Aug 08, 2018 at 12:41 PM

    Try instead of:




    Add comment
    10|10000 characters needed characters exceeded