Passing a range to SAPBEX.XLA!SAPBEXSetFilterValue

[Former Member]

Hello

I need to pass a range of fiscal periods to the following function:

Run("SAPBEX.XLA!SAPBEXSetFilterValue", myFilter, "", myRange)

When 'myfilter' is a single value, I pass a fiscal period, which is a concatenation of fiscal variant(lets say Z9) and the period (lets say 2005001), which is Z92005001. The filter works properly.

However, I am unable to pass a range of fiscal period to 'myfilter. Any help is highly appreaciated.

regards,

Bincy

[Former Member]

Hi Bincy,

Sorry that I am so late in responding. I hope that the reference Kenneth send was helpful. I'd like to add something to that.

The reference that Kenneth forwarded addresses setting multiple filter values. In your case, you might want to set a range instead of setting multiple, individual values.

In this case, the steps are similar, but with one important difference:

1. use the SAPBEXsetFilterValues function to set the intial filter

2. search the SAPBEXfilters worksheet to find the filter value that was just set

3. change the cell in column HG from "EQ" to "BT"

4. add the other end of the range to cells in columns HI and HK.

- Pete

[Former Member]

I spent two weeks talking with SAP about this very topic and I had to tell them that it doesn't support multiple values. The function is not coded to accept multiple values.

There is a workaround....Search the forum for SAPBExSetFilterValue and you will see what others have done. Peter Knoer's response from Sep 13, 2004 9:21 PM provides the code for the workaround.