SAP GUI 730 with Bex analyzer problem

[former_member327010]

Hi all,

we have a problem running transaction rrmx from SAP. We get erron in excel 2003:

Run time error 91 Object variable or with block variable not set

When i click debug i get the line:

LogOn = pAddin.ExcelInterface.LogOn(iUser:=iUser, iSystemID:=iSystemID, iServer:=iServer, iSysNo:=iSysNo, iLnaguage:=iLanguage, iClient:=iClient, iSNCQuality:=iSNCQuality, iTicket:=iTicket, irouter:=irouter)

I have found a very similar thread http://scn.sap.com/thread/716372 , but the workaround is not really what i imagined. Any other idea how to fix tihis?

Our enviroment:

BW System

Component version: EHP6 for SAP ERP 6.0

SAP_BW:  Release 731, Pacth level 5

SAP GUI for Windows

Release: 730

Patch level: 3

MS Excel 2003

Thank you.

Best Regards,

Martin Zluky

[Former Member]

Hi,

I'm facing the same problem.

How did you solve this problem? Same error message and same line in Visual Basic code.

The only difference is that I'm working with MS Office 2010.

Thanks!

[former_member327010]

Hi alberto,

it is a very old thread but as far as i can remember i discussed this problem with our basis team and they used the solution described in the first post: with one difference. They didnt re-installed SAPGUI but only netframework and office and tried different SP till it worked.

Hope this helps.

Regards,

Martin Zluky

[Former Member]

Thanks Martin,

I'm investigating and I've found exactly what happens to me:

SAP Note: 1962327 - No response from the Toolbars in BEx Analyzer

We should be able to see yellow help button, but we have it blue instead, what indicates of an inactive toolbar. I must follow that note.

[Former Member]

Hi again Martin,

In the end I had to uninstall SAPGui and SAPBusiness Explorer, and reinstalling it, that solved my problem.

Regards

[RolandKramer]

Hi,

Please check, if your Problem is mentioned on this SCN page

http://scn.sap.com/docs/DOC-35785

Best Regards Roland