BEx Inf. Broadcasting error executing workbooks running SAPBEX.XLA macro

[Former Member]

Hi

I'm using the BEx Information Broadcasting to precalc workbooks and it works fine for the most of them.

I cannot execute those workbooks running VBA Macros from the SAPBEX.XLA file, as the SAPBEXreadWorkbook macro to open a second workbook.

I'm using a VBA code like this :

strWBID = "8QT8NTPJPXIQ8FM5Z8MQGA7ST"

strTmp = Run("SAPBEX.XLA!SAPBEXreadWorkbook", strWBID)

The Information Broadcasting execution ends with the VBA error message "Run-time error 1004 : SAPBEX.XLA could not be found".

Can anybody help ?

[Former Member]

Hello

I have the same problem.

Have you a solution ?

Log file below :

10/03/2009 13:47:12 ->

target: [SAPBEXPRECD8F23QXZ84NGO8CRXJD47N51X_0.xls]Feuil1!$A$19

10/03/2009 13:47:12 ->

error: 1004Impossible de trouver la macro ''SAPBEXPRECD8F23QXZ84NGO8CRXJD47N51X_0.xls'!SAPBEXonRefresh'.

10/03/2009 13:47:12 ->

RFC function RRY_GRID_CMD_PROCESS returned ok

10/03/2009 13:47:12 ->

cBExRunRunQueriesInWorkbook: Read Variable Table

10/03/2009 13:47:12 ->

RFC function RRY_REPORT_CLOSE returned ok

10/03/2009 13:47:12 ->

Disconnect

10/03/2009 13:47:12 ->

Before - not p_bexGlobal Is Nothing

10/03/2009 13:47:12 ->

Before p_bexGlobal.SAPConnection

10/03/2009 13:47:12 ->

p_bexGlobal.SAPConnection became nothing

10/03/2009 13:47:12 ->

after p_bexGlobal is nothing

10/03/2009 13:47:12 ->

setting the p_connectionObj to nothing

10/03/2009 13:47:12 ->

]

3/10/2009 1:47:12 PM -> StartCalc-4

3/10/2009 1:47:13 PM -> Returning the excel application that was created in thread 3

3/10/2009 1:47:13 PM -> Returning the excel application that was created in thread 3

3/10/2009 1:47:13 PM -> Returning the excel application that was created in thread 3

3/10/2009 1:47:13 PM -> Calculated new file name: C:\WINDOWS\TEMP\BW\Analyzer\Workbooks\SAPBEXPRECD8F23QXZ84NGO8CRXJD47N51X_0.xls in thread 3

3/10/2009 1:47:13 PM -> Calculated new file name: C:\WINDOWS\TEMP\BW\Analyzer\Workbooks\SAPBEXPRECD8F23QXZ84NGO8CRXJD47N51X_0.xls in thread 3

3/10/2009 1:47:13 PM -> LeaveRS_PREC_PRECALULATE1

3/10/2009 1:47:13 PM -> Calculated new file name: C:\WINDOWS\TEMP\BW\Analyzer\Workbooks\SAPBEXPREC3CFMOQK5QXL5P654UV34KQKW3_0.xls in thread 3

3/10/2009 1:47:13 PM -> Locking MapSessionid in Release in thread 3

3/10/2009 1:47:13 PM -> Locked MapSessionid in Release in thread 3

3/10/2009 1:47:13 PM -> Unlocked MapSessionid in Release in thread 3

3/10/2009 1:47:13 PM -> Calculation Request BIPREC0A453218442849B6610F325500 finished in thread: 3and job ' '.

[Former Member]

Hi,

SAPBEX.XLA is not a workbook, but a VBProject. So if you want to run this macro you may just call SAPBEXreadWorkbook(strWBID).

Regards,

Juergen

[Former Member]

Hi Juergen,

thanks a lot for your answer, but if I tried to execute the macro directly using a call:

strWBID = "8QT8NTPJPXIQ8FM5Z8MQGA7ST"

Call SAPBEXreadWorkbook(strWBID)

I get a VBA Compile error: Sub or function not defined

both if I refresh the workbook from the BEx Menu and if I execute the workbook by the Information Broadcasting.

It looks like the Information Broadcasting Service cannot find the VBAProject SAPBEX and SAPBEX0 although I can see both of them available into the VBA Project window when the error occurs.

There's anyelse missing I should do ?