on 12-07-2007 2:06 PM
Dear all,
I am trying to use the BExapi SAPBEXsetFilterValue in BEx 7.0 and get the error 1004: "Unable to get the Intersect property of the Application class".
The code is the following:
Sub test()
Call SAPBEXsetFilterValue("Sales")
End Sub
Public Function SAPBEXsetFilterValue(intValue As String, Optional hierValue As String, Optional atCell As Range) As Integer
If atCell Is Nothing Then Set atCell = Application.ActiveCell
Dim pAddin As Object
Set pAddin = CreateObject("com.sap.bi.et.analyzer.addin.BExConnect")
SAPBEXsetFilterValue = pAddin.SAPBEXsetFilterValue(ActiveWorkbook.Name, intValue, hierValue, atCell)
End Function
Does anyone know how I can fix the problem?
Thanks a lot in advance,
Rainer Sigg
Rainer,
Did you ever resolve this problem? I am encountering the same error.
Thanks,
Kelly
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
9 | |
9 | |
8 | |
7 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.