Open with VBA - hide passwords in code?

B

Buffyslay

hi

i have a piece of code where i need to open various workbooks - these
all have passwords (i know what they are).

what i dont want to do is code in the passwords into my vba as anyone
could look at them and see exactly what they are.

is there a way i can encrypt the passwords in the code?

i dont really want to password protect them as i have a tendancy to
forget them
 
T

Tom Ogilvy

There is no built in support for it. You could write your own routine to do
it (decrypt the password), but someone could read your code and try to
understand the algorithm. Not sure they would actually bother, however.

workbooks.Open Filename:="ABC.xls", Password:=MyDecryptFunction("RSM13V")
 
Top