Cannot find SAPBEx module

[Former Member]

Hello BW experts,

I cannot see the SAPBEx module in the VB Editor when I open a BEx workbook.

I am using BEx2004s and Excel 2003.

I have set the Macro security to Medium level and checked the option for "Trust access to Visual Basic Project".

Is there anyone can tell me why and how to get the SAPBEx module?

In addition, I have gone through some of the posts in the forum, and The Exit Tab in the Workbook settings was mentioned a few times. I tried to follow the instructions by changing into Design mode but I had no hope to find the "Exit tab". I need some help on that too.

Points will be rewarded.

Thank you very much!

Best Regards,

Cindy

Edited by: Cindy Lee on Feb 19, 2008 10:56 AM

[Former Member · Accepted solution]

Hi Cindy,

set the Macro security to LOW level & check it.............

Try to check whether SAPbex files present are not?

check for this file

sapbexc.xla

sapbex0.xla also......

[Former Member · Accepted solution]

Hello vijay,

Thank you for your quick reply.

I have changed the Macro Security level to low already. Still no hope.

There is SAPBEX (sapbex.xla) in the Project window of Visual Basic Editor but it can only be opened with password.

Is there anything I missed?

Thanks in advance.

Best Regards,

Cindy

[Former Member · Accepted solution]

HI Cindy,

Did u find sapbexc.xla

file in u'r systems............

[Former Member]

Hello vijay,

Yes, there are four files in the SAP folder in my system.

sapbexc.xla

sapbexs.xla

sapbex0.xla

sapbex.xla

Best Regards,

Cindy

[Former Member]

Hi Cindy,

Your workbook might be protected(it might have password protected)

[ChandranGanesan]

Hello Cindy,

As of my knowledge the SAPBEX.xla is password protected by default. Even if you change the macro security you won't be able to change it.

Thanks

Chandran

[Former Member]

Hello vijay,

You mean if I have those files in the folder, it means that my workbook might be protected with password?

I created the workbook by myself, I did not set any password at all. How can it be automatically protected with password?

Please advise.

Best Regards,

Cindy

[Former Member]

Thank you Chandran.

But there are many posts about how to change the codes when SAPBExonRefresh is called.

I would like to re-format the worksheet whenever the query is refreshed.

Any idea?

Thanks in advance.

Best Regards,

Cindy

[ChandranGanesan]

Hello Cindy,

Have you tried to set the format using the sheets under VBAProject?

Please check whether you have seen this threads, this may give you some ´hints

I'm still looking for a exact fix and let you know if I found some.

Thanks

Chandran

[Former Member]

Hello Chandran,

I created a module called SAPBEX and insert the SAPBEXonRefresh routine. Somehow it works!

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

MsgBox "Hello"

End Sub

Whenever I refreshed the query, it triggers the routine above.

According to the online help, it is automatically generated when a query is inserted into the Workbook but it did not happen to mine.

My problem has been solved.

Thank you for your help anyway.

Best Regards,

Cindy