Example of an Excel VBA application using the mooAwDetach function:
Public Sub mooAwDetach() 'Detach Analytic Workspaces
Dim boo As Boolean
If Not oregistered Then: boo = regQ:
If Not o.connected Then
boo = o.connect
boo = o.connected Else
boo = True
End If
If boo = True Then
boo = o.mooAWDetach("GLOBAL.GLOBAL")
Else
Debug.Print "Unable to Connect"
Debug.Print o.getlastmooerr
End If
End Sub
Detaches an analytic workspace. MooAwDetach does not perform an update.
mooawdetach(“ [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
