Visual Basic Applications (VBA) Refresh

Using the following syntax, cmdtyView for Excel users can invoke a refresh via VBA.

Application.Run "BC_RefreshAll"

You can trigger a data refresh by pasting the VBA code into the Worksheet. Double-click the desired Sheet object in the VBA Project Pane to open the text editor (blank white sheet) within the Visual Basic Editor.

Open

Example of code below:

Sub BC_Refresh()
Application.Run "BC_RefreshAll"
End Sub

Run the macros from the Macros button in the Developer tab or assign a macro to a button from the Insert section in the Developer tab.

Open