Hi Standa,
i have a new problem related to the same issue.
the description of how to use the API is written in hel.sap.com.
It is described as follows:
Function SAPBEXsetFilterValue(intValue As String, Optional hierValue As String, Optional atCell As Range) As Integer
Filtering with cell atCell (if this parameter is missing, then the active cell is taken as the basis)
The internal filter value must be entered in the parameter intValue. Please note that this value can be displayed differently from the external value displayed in the filter cell. You can either use SAPBEXgetFilterValue or carry out the filter process once manually with the log book function switched on in order to determine the internal value for a known external value. The internal filter value is noted in the log.
Enter the parameter hierValue when dealing with a node of a certain characteristic hierarchy with the filter value.
"intValue = <blank>" means "do not filter anymore"
If no connection to a BW server exists the function starts a logon dialog.
The function produces a context error if atCell is not a filter cell.
My problem:
i used this command with the parameter Optional atCell As Range . As range i put the cell in the workbook where the characteristic is listedin a navigation pane for ex. J24. This kind of coding is very sensitive because in J24 must always be the characteriustic which i want to filter. If i change the dimensions in the navigation pane or is the navigation pane is removed somewhere else the filtering does not work.
My question: does anybody have an idea how to program it more flexible without harcoding the cell into the comand?
Thanks for answers and kind regards,
Murat