Skip to Content

"SAPOpenWorkbook" method does not work in Analysis 2.5.1

Sep 08, 2017 at 08:12 AM


avatar image
Former Member

Hi experts,

I would like to open one saved Workbook (called “AMSTEST”) with VBA from MS Excel. This WB was saved on NetWeaver Platfor server -> according to docu of the analysis for MS Office should be technical name of workbook enough.

Sub wbOpen()
    Dim lResult As Long
    lResult = Application.Run("SAPOpenWorkbook", "AMSTEST", "DS_1")
End Sub

I got this error message

Analysis Add-in was installed succesfully und works for another issues fine.

If I run this VBA code, add-in is already loaded -> I assume it should work fine, but does not.

I am using this version

Can someone give me any help to solve this problem or explain what I make false?

Thank you very much in advance.

Michal P.

vystrizek.jpg (23.0 kB)
vystrizek1.jpg (35.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Sep 14, 2017 at 11:12 AM


I have found one thing. If I add a new data source from the same server and the same client -> log on have to be done again and after that if I run this macro the code works as well. It seems to be a root cause somewhere in the log-in procedure or something like that.

Do you have some from you the same experience or similar?



10 |10000 characters needed characters left characters exceeded