![]() ![]() LResult = Application.Run("SAPAddMessage", "You have updated the data!", "INFORMATION") Having created a dashboard with SAP data externally pulled via the Analysis for Excel SAP plugin (crosstab linked to multiple pivot tables on multiple sheets), I am looking to add a macro to a button that calls for refreshing the SAP crosstab and then refreshing all pivot tables in the workbook.Ĭode I found for both steps is: Sub Button2_Click()Ĭlick = Application.Run("SAPExecuteCommand", "Refresh") While I know my way around Excel, I am new to VBA. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |