the macro 'sapbex.xla!reponewquery' cannot be found

[Former Member]

Hello everybody!

I am getting an error message 'The macro sapbex.xla!repoNewQuery cannot be found'. And it continues with all other icons in the BEx toolbar in excel. What should I do now?

(I have deleted all the saplogon and installed it again !

My Excel edition is 2003 and the degree of macro is low!)

your early help would be appreciated.

[Former Member · Accepted solution]

Hi Wang,

This file is used to open bw frontend..........

so reinstal u'r front end..............

or consult basis people they will reinstall the gui.

Regards,

Vijay.

[Former Member · Accepted solution]

Hi vijay,

The logon in my PC sever is installed completelThe other people using the same system do well!

[Former Member · Accepted solution]

Hi Wang,

If u'r search in u'r pc for 'bex' files u should get

sapbex.xla

sapbex0.xla

sapbexc.xla

files.........

in u'r pc sapbex.xla might have get corrupted........

Regards,

Vijay.

[Former Member · Accepted solution]

I have coped a new one from another people's computer who has a well-done software! But it does not work too! The dialog box is" runtime errer"!

Edited by: Wang Xi on Mar 4, 2008 12:38 PM

[Former Member · Accepted solution]

Try ton reinstal GUI / consult basias guy.

Regards,

Vijay.

[former_member186647 · Accepted solution]

In your system, if Analyzer works fine for one type of user and not working for other users, that means something prevents the Auto_Open macro from running. Because of that the toolbar is not renamed and the buttons are not mapped correctly. We just want to inform you that there is no problem with

Installtion as well as Analyzer. The problem is with user login. It may be due to the settings in HKEY_CURRENT_USER.

Exd files cache activeX component information. If the component changes without removing the exd file (which created when the component is first used), then the system will be out of sync.

Go into a command prompt and type the following DOS commands:

> CD \Document And Settings

> DEL /S /A:H /A:-H *.EXD

Thanks

Ezhil

[Former Member · Accepted solution]

Wonderful!!!

This resolve my issue! Thanks very Much!

Maybe It need to chande unit on you PC. Use the command CD with option /D

For example CD /D e:\

for chang unti and pass to volume E:\

Edited by: Pierfrancesco Marvulli on Sep 5, 2011 2:18 PM