All,
Below VBA code I am using to refresh Oracle BI report data in Excel. It is connected to Oracle BI using Smart View.
I am able to refresh data using below code. It shows a message once data gets refreshed such as 'Table1 is refreshed', Is there a way to suppress this message? 'Application.DisplayAlerts = False' does not work. Due to this message macro can not proceed further.
Thanks
Below VBA code I am using to refresh Oracle BI report data in Excel. It is connected to Oracle BI using Smart View.
I am able to refresh data using below code. It shows a message once data gets refreshed such as 'Table1 is refreshed', Is there a way to suppress this message? 'Application.DisplayAlerts = False' does not work. Due to this message macro can not proceed further.
Thanks
Code:
Sub RefreshWorksheet()
Application.DisplayAlerts = False
Call HypMenuVRefresh
Application.DisplayAlerts = True
End Sub