Open Multiple Password Protected Workbooks with Macro

S

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.
 
T

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
 
S

ScottMSP

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

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

Top