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