‎2020 Oct 23 11:45 AM
Hello,
i'm trying create customizing user interface using standart Analysis tool. I create new tab and new button. This button call a macros which does the opening another workbook from server.
Macro looks like that:
iResult = Application.Run("SAPOpenWorkbook", "MyWBName", "DS_1")
But when I but when I click the button, the workook opens (its name appears in the Analysis Component Panel), but I do not see an additional open workbook. If you call the macro from the module, then the new book opens in the window as expected. Please,please, tell me - what could be the problem? Analysis version - 2.8.401.94659
‎2020 Oct 23 12:03 PM
Excel Version - MS Excel for Microsoft 365 MSO (16.0.13231.20110), 32-bit