Open Multiple Password Protected Workbooks with Macro

[ScottMSP]

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.

 

[Tom Hutchins]

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]

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