Visual Basic for Applications macros are not supported by Excel Online.
Purpose
Provides a means to check if Velixo is currently running background functions.
See Introduction to Velixo's VBA functions for general usage information.
Syntax
objVelixo.ActiveFunctionsCount
objVelixo- a variable that represents an instance of the Velixo VBA functions class.
Example
Use ActiveFunctionsCount to provide completion feedback after a background RefreshFull.
Dim velixoObj As Velixo_Reports.VBA
Set velixoObj = CreateObject("Velixo.Reports.Vba") velixoObj.RefreshFull True
Do While velixoObj.ActiveFunctionsCount > 0 Or Application.CalculationState = xlCalculating
DoEvents
Sleep 500 'Sleep needs to be imported using declare statement
Loop
MsgBox "Refresh Completed!"