Skip to Content
avatar image
Former Member

"SAPOpenWorkbook" method does not work in Analysis 2.5.1

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    Hi,

    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?

    Thanks,

    Bye

    Add comment
    10|10000 characters needed characters exceeded