Show TOC

Assigning a Control Form to a MacroLocate this document in the navigation structure

You can assign a control form to a macro.

Example

Assigning a button to the Refresh macro
Option Explicit

Sub Button5_Click()

Dim cofCom As Object
Dim api As Object

Set cofCom = Application.COMAddIns("SapExcelAddIn").Object
Set api = cofCom.GetPlugin("com.sap.epm.FPMXLClient")

api.Refresh

End Sub