Encrypt password for database access

[Romulo Avila]

Good Morning,


I have a spreadsheet that accesses a database, would have some way to encrypt the password or some way that the password can not be viewed?

==> Connection example

Set gCon = New ADODB.Connection
gCon.Open "provider=msdaora; data source=BDDados01; user id = John; password = ******x1234;"


Thank you for your help

[Simon Lloyd]

Take a look in our knowledge base http://www.vbaexpress.com/kb/getarticle.php?kb_id=951

[Romulo Avila]

Good afternoon,

I am new to VBA and I was wondering how I will use this function to encrypt the password.

Thanks again.