Password for Macro in SAPBEX

[Former Member]

Hi,

I am trying to create a macro in a workbook. I'm following the steps from :

http://wiki.sdn.sap.com/wiki/display/BI/SAPBWMacros--BExFormatting+Features

However, its requesting for password when i click on sapbex.xla.

Can i know how i can retrieve this password. I have searched in SDN, but cant find much info on this.

Appreciate help from those who are familiar.

Thanks.

Regards,

Maili

[Former Member · Accepted solution]

hi,

check out this link:

and

http://www.bigresource.com/VB-VB-excel-to-vbscript-jbRDb3UBJT.html

hope it will help to you.

Chandoo7

[MartinMaruskin]

What version of GUI and BW Frontend do you have? Might be it is corrupted? See following note:

1447318 - Protection is removed after refreshing the workbook

[Former Member]

HI All,

thanks for all the responses...it was very very helpful.

i manage to solve it as per the previous sdn link

created a module called SAPBEX and insert the SAPBEXonRefresh routine.

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

---> added on the code according to macro recording e.g module 1.

End Sub

Thank you very much.

Regards,

Maili