Can we have refresh/publish buttons in SAC excel for add-in?

[eodiase1]

Hi Team,

Would like to know if SAP has introduced any VBA functions to refresh/publish data in SAC Excel Add-in? any alternate work arounds?

Thanks.

[N1kh1l]

@eodiase1 

There are no explicit vba's  but you can use the keyboard shortcuts and use Application.sendkeys() to achieve similar functionality. 

For Windows based Excel Add-in you can below to Refresh all Tables.

Create a button and assign the below macro

Sub Refresh()
Application.SendKeys ("+^%{F5}")

End Sub

There are no shortcuts for Save but there is for process data

Sub Process()
Application.SendKeys ("+^%{ENTER}")
End Sub

All shortcuts can be seen here

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD_OFFICE/c637c9ff5d61457eb415ce161e38e57b/559e9547681e47...

Application.sendkes() details can be seen here

https://learn.microsoft.com/en-us/office/vba/api/excel.application.sendkeys

Nikhil