Opening a passworded workbook

Mar 4th, 2002, 06:44 AM

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.

Mar 4th, 2002, 06:58 AM

Tis ok got it

Marvelous how a simple relook can solve most things

)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 06:44 AM	#1
Guest Posts: n/a	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.

Mar 4th, 2002, 06:58 AM	#2
Guest Posts: n/a	Tis ok got it Marvelous how a simple relook can solve most things )