VBA commands: RefreshFull

Visual Basic for Applications macros are supported in Excel Desktop for Windows only.

Description

Performs a Full Refresh of the data in the report.

See Introduction to Velixo NX VBA commands for general usage information.

Syntax

CODE

objVelixo.RefreshFull [AsyncRefresh]

objVelixo - A variable that represents an instance of the Velixo_NX_Tools VBA command class.

Arguments

Name

Required / Optional

Description

AsyncRefresh

Optional

Specifies whether the refresh should be done in the background.

Accepted values: True and False

Defaults to False.

When AsyncRefresh is set to False, Refresh runs synchronously and returns after data is retrieved, but Velixo NX calculations may still be running. While Velixo prevents calculations from being blocked, actions (e.g. hiding zero rows) may run before calculations finish, causing unexpected results.

We highly recommend setting AsyncRefresh to True and using a callback for any logic that depends on completed calculations.

Example - Asynchronous full refresh

CODE

Dim velixoObj As Velixo_NX_Tools.VBA
Set velixoObj = CreateObject("Velixo.NX.Tools.Vba")

Application.DisplayAlerts = False

velixoObj.RefreshFull True