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.