Open Multiple Password Protected Workbooks with Macro
 

Hello -

I have scoured the discussions boards, but have not found an answer to my
question and thus this post.

I have 10 workbooks that are each individually password protected with
unique passwords that I would like to be able to open all 10 at once using a
Macro.

I want to avoid having to individually click on and open each workbook and
key the unique password.

I plan for this to be part of a broader Macro doing other steps, but I have
not been able to find the solution to this part of the problem.

Thanks in advance.

Open Multiple Password Protected Workbooks with Macro
 

You can provide the password with the Workbooks.Open method, like this:

Workbooks.Open Filename:="D:\Data\Book1.xls", Password:="asd"
Workbooks.Open Filename:="D:\Data\Book2.xls", Password:="bnm"
Workbooks.Open Filename:="D:\Data\Book3.xls", Password:="cvb"
'etc.

Does that do what you want?

Hutch

"ScottMSP" wrote:

Hello -

I have scoured the discussions boards, but have not found an answer to my
question and thus this post.

I have 10 workbooks that are each individually password protected with
unique passwords that I would like to be able to open all 10 at once using a
Macro.

I want to avoid having to individually click on and open each workbook and
key the unique password.

I plan for this to be part of a broader Macro doing other steps, but I have
not been able to find the solution to this part of the problem.

Thanks in advance.

Open Multiple Password Protected Workbooks with Macro
 

Yes... it almost seems too simple, but it definitely worked. I can use it as
a part of the larger macro. Thank you!

"Tom Hutchins" wrote:

You can provide the password with the Workbooks.Open method, like this:

Workbooks.Open Filename:="D:\Data\Book1.xls", Password:="asd"
Workbooks.Open Filename:="D:\Data\Book2.xls", Password:="bnm"
Workbooks.Open Filename:="D:\Data\Book3.xls", Password:="cvb"
'etc.

Does that do what you want?

Hutch

"ScottMSP" wrote:

Hello -

I have scoured the discussions boards, but have not found an answer to my
question and thus this post.

I have 10 workbooks that are each individually password protected with
unique passwords that I would like to be able to open all 10 at once using a
Macro.

I want to avoid having to individually click on and open each workbook and
key the unique password.

I plan for this to be part of a broader Macro doing other steps, but I have
not been able to find the solution to this part of the problem.

Thanks in advance.