Example of an Excel VBA application using the mooAwAttached function:
Public Sub mooAwAttached() 'Check if an Aw is attached
Dim boo As Boolean
If Not oregistered Then:
If Not o.connected Then
boo = o.connect
boo = o.connected
Else
boo = True
End If
boo = regQ:
boo = o.mooAwAttached("EXPRESS")
If boo = False Then
MsgBox "No Not Attached"
Else
MsgBox "Yes Attached"
End If
End Sub
Returns TRUE if the specified analytic workspace is attached (open)
mooAwAttached(“ [aw name] “)
Syntax
Microsoft®, WINDOWS®, Microsoft Excel®, Microsoft Office® are registered trademarks of Microsoft Corporation.
ORACLE® is a registered trademark of ORACLE Corporation.
® SDMC Consulting Limited 2010