I'm trying to open the context member selector pop-up window through a vba button on my excel worksheet.
I've managed to step successfully through the code, however I can't get the function to do what it's supposed to be doing? Am I missing any extra parameters i.e. what additionally should I amend to the piece of code to open up the TIME dimension context member selector through my code?
Dim EPM10 As New FPMXLClient.EPMAddInAutomation EPM10.OpenDimensionAndMemberSelector(EPM10.GetActiveConnection(ActiveSheet))
Any help in this regard will be appreciated.