Skip to Content
0
Former Member
Oct 06, 2014 at 08:10 AM

SAPCallMemberSelector and range values

214 Views

Hi,

I'm trying to get the range of a variable which is set through a prompt in order to assign new values to this variable and rerun the query via VBA.

In the prompt two input boxes for this variable are shown. So I assume that the following command:

Dim vResult as Variant

vResult = Application.Run("SAPCallMemberSelector", "DS_1", "PROMPT", "VARIABLE")

delivers the entered values. Unfortunately the variable "vResult" is empty and does not return any error.

Since the documentation says that the function "SAPCallMemberSelector" only returns three kinds of return types and in my case the function neither returns an error nor "False", I assume that "SAPCallMemberSelector" can't handle range values. I'm using Analysis 1.4 SP8.

Am I doing something wrong or is the function "SAPCallMemberSelector" not able to handle range values?

Regards

Andreas