Skip to Content
0
Sep 08, 2017 at 08:12 AM

"SAPOpenWorkbook" method does not work in Analysis 2.5.1

438 Views

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.

Attachments

vystrizek.jpg (23.0 kB)
vystrizek1.jpg (35.7 kB)