Skip to Content
author's profile photo Former Member
Former Member

VBA Macro SetFilter

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Mar 20, 2008 at 05:36 PM

    Rainer,

    Did you ever resolve this problem? I am encountering the same error.

    Thanks,

    Kelly

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.