Example of an Excel VBA application using the disconnect function:
Public Sub disconnect()
'Disconnects Excel From Oracle OLAP
If Not oregistered Then: boo = regQ:
boo = o.disconnect
If boo = True Then:
MsgBox "Disconnected OK"
Else
MsgBox "Not Disconnected"
End If
End Sub
Closes the current connection to an Oracle OLAP instance. No further Analytic Workspace operations are carried out including DML detaching the analytic workspace..
Microsoft®, WINDOWS®, Microsoft Excel®, Microsoft Office® are registered trademarks of Microsoft Corporation.
ORACLE® is a registered trademark of ORACLE Corporation.
® SDMC Consulting Limited 2010
