Visual Basic Applications (VBA) Refresh
Using the following syntax, Barchart for Excel users can invoke a refresh via VBA.
Application.Run "BE_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.
Example of code below:
Sub BE_Refresh()
Application.Run "BE_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.
Â