Syntax
mooencrypt(“[password]”)
Example of an Excel VBA application using the mooEncrypt function:
Public Sub mooEncrypt()
'Generate an encrypted password for a connection xml file
'The Output in the VBA immediate window can be pasted in to a connection file
If Not oregistered Then: boo = regQ:
Debug.Print o.mooEncrypt("myPasswordHere")
End Sub
Accepts a string and returns an encrypted version of the string that can be used in constructing a valid XML connection file.
The mooEncrypt function can be used to generate a password that can be copied and pasted into an XML connection file.
Note there is no decrypt equivalent function as it is anticipated that all Oracle account passwords could be reset by the local DBA.
Microsoft®, WINDOWS®, Microsoft Excel®, Microsoft Office® are registered trademarks of Microsoft Corporation.
ORACLE® is a registered trademark of ORACLE Corporation.
® SDMC Consulting Limited 2010
