Opening a passworded workbook

[Guest]

I have several workbooks that I work on, and have saved with passwords to protect them, however I now need to allow another workbook to be able to open them in the background to retrieve the data from within.

My question is can I open these protected workbooks, without having them prompt me for the passwords all the time, I need to keep the data secure but also need to open different workbooks at different times.

I was hoping that I could just have in my macro something like
Workbooks.Open FileName:="data1.xls" password="password1"

Naturally I know all the required passwords.
But no luck yet

Any help would be appreciated.

 

[Guest]

Tis ok got it

Marvelous how a simple relook can solve most things )