cancel
Showing results for 
Search instead for 
Did you mean: 

VBA API Not Supported in 2004?

Former Member
0 Kudos

Are the BEx VBA API functions/subs no longer available in 2004s (ie, SAPBEXsetFilterValue)? If the functions are not supported, does anyone know if SAP is replacing them?

Kenneth

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

what Ifound out so far is :

the new BI7 Queries in Excel BEX will not support the API that could be used in BW3.x.

The API is still available but for example the hidden sheets like Filters and queries are not existing anymore.

I severely used the API but presently there is no API ( at least I haven't found an API documentation describing how to filetr or navigate by help of macros.

For most customer it is essential to 'remote control' the functionality.

Hope that helps

Joerg

vinay_bedre2
Participant
0 Kudos

Hello Kenneth,

We have not changed any API in 2004s.

For API's and its definition kindly refer to the following link.

http://help.sap.com/saphelp_bw21c/helpdata/en/f1/0a55f9e09411d2acb90000e829fbfe/frameset.htm

All the workbooks defined in 3.X are compatible in 2004s.

Should you require further info., let me know,

Kind Regards,

Vinay

Former Member
0 Kudos

I would like to point out that the <b>new 2004s BEXAnalyzer.xla does not support ALL of the functions from 3.5</b>.

I'm trying to determine what SAP is providing as an alternative solution. I understand that I can physically use the old 3.x analyzer, but I'm trying to get away from it.

Kenneth

The following is copied from BEXAnalyzer.XLA:

Public Function SAPBEXcopyFilterValue(fromCell As Range, Optional atCell As Range) As Integer

'Not supported in 7.0

extErrorBegin ("3.x API SAPBEXcopyFilterValue called - NOT SUPPORTED IN 7.0!")

SAPBEXcopyFilterValue = 700

p_extErrorText = "API not supported in 7.0"

End Function

Public Sub SAPBEXpauseOn()

'Not supported in 7.0

extErrorBegin ("3.x API SAPBEXpauseOn called - NOT SUPPORTED IN 7.0!")

p_extErrorText = "API not supported in 7.0"

End Sub

Public Sub SAPBEXpauseOff()

'Not supported in 7.0

extErrorBegin ("3.x API SAPBEXpauseOff called - NOT SUPPORTED IN 7.0!")

p_extErrorText = "API not supported in 7.0"

End Sub

vinay_bedre2
Participant
0 Kudos

Hello Kenneth,

Due to some techinal reasons, the <b>New 2004s BEXAnalyzer.xla does not support ALL of the functions from 3.5.</b>.

Just now i learn this information.

Should you require further info, let me know.

Regards,

Vinay

Former Member
0 Kudos

Kenneth,

The VBA XLA file within the new BEx Analyzer in 2004s is completely unlocked. You can launch the Analyzer open the Visual Basic Editor and peruse through the various functions available.

Hope this helps.

Cheers,

Scott