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.

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

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