Call EPM Functions (EPMSelectMember) using Excel Button

Hi all,

I am trying to call EPMSelectMember in VBA code but keep on having error.

Below is my Code in VBA, I think I had put the incorrect member.

The member name should be the dimension name ?

Can anyone advise me on what parameter I should pass in the function ?

A sample code would be really appreciated.

Sub Button1_Click()

    Dim b As New FPMXLClient.TechnicalCategory
    
    b.EPMSelectMember("RESOURCE_PLAN","A5")

End Sub

Regards,