Open with VBA - hide passwords in code?

  • Thread starter Thread starter Buffyslay
  • Start date Start date
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
 
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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Anyone Suggest a Way to Remove a Password from a PST File Without Outlook? 1
Excel Protection 2
Excel prompts for VBA password when opening 5
Excel VBA Project Has Protection? 2
How to bypass password when pasting FROM a protected workbook 3
VBA Password - Excel keeps prompting for it 0
Knowing is a workbook's VBA project has password or not 2
VBA Password Workaround 1

Back
Top