Hello everyone,
This is my very first post in here and I'm curious if someone of you always already had the same problem to solve!
Setting any single filter values with
Function SAPBEXsetFilterValue(intValue As String, Optional hierValue As String, Optional atCell As Range) As Integer
works fine!
But what, if it's <b>not about setting a single value, but a value range</b>, in my case everything before a specific date (e.g. "< 30.04.2005")
Just using this string as a parameter doesnt work.
Neither works replacing the date in all worksheets (even in the "veryhidden" ones)
The reason for this request is, that I always want to select figures where the date at each line is at least earlier than 10 days ago from today, and I don't want to enter it manually everytime.
Thanks a lot and have a great day!
Reinhard