Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to open and remove passwords in bulk | Excel Discussion (Misc queries) | |||
pre-authorized to open a file without passwords? | Excel Discussion (Misc queries) | |||
2 separate passwords (both valid) to open file | Excel Discussion (Misc queries) | |||
Excel passwords are changing when two workbooks are open. | Excel Worksheet Functions | |||
Setting VBA passwords from within code | Excel Programming |