Open with VBA - hide passwords in code?
 

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

Open with VBA - hide passwords in code?
 

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")
--
Regards,
Tom Ogilvy

"Buffyslay" wrote in message
m...
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