The Excel formula `I_INTEGRATION_ACTIVE` retrieves whether Invantive Control for Excel is fully integrated and active.
Returns: whether Invantive Control for Excel is fully integrated and active.
## Examples
The following code shows a message when Invantive Control for Excel is not active before trying to retrieve the full name from Exact Online:
```vba
Option Explicit
Sub RunSql()
On Error GoTo Catch
Dim result As Variant
'
' Get full name of current user.
'
If Not I_INTEGRATION_ACTIVE() Then
MsgBox "Invantive Control for Excel is not available. Please use the Tools menu to activate it."
End If
result = InvantiveControlUDFs.I_SQL_SELECT_SCALAR("fullname", "Me")
MsgBox ("Result is '" & result & "'.")
Finally:
Exit Sub
Catch:
HandleError "RunSql"
End Sub
```
The following code shows a message when Invantive Control for Excel is not active before trying to retrieve the all properties of general ledger accounts from Exact Online:
```vba
Option Explicit
Sub RunSqlTable()
On Error GoTo Catch
Dim result() As Variant
'
' Get list of GLAccounts.
'
If Not I_INTEGRATION_ACTIVE() Then
MsgBox "Invantive Control for Excel is not available. Please use the Tools menu to activate it."
End If
result = InvantiveControlUDFs.I_SQL_SELECT_TABLE("select * from ExactOnlineREST..GLAccounts")
Finally:
Exit Sub
Catch:
HandleError "RunSqlTable"
End Sub
```