Skip to Content
0
Former Member
Mar 13, 2007 at 06:28 PM

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

56 Views

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 ?