Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to open multiple password protected workbooks | Excel Programming | |||
Excel Macro to open password protected workbooks? | Excel Discussion (Misc queries) | |||
macro to batch fix errors on password protected workbooks | Excel Programming | |||
linking to multiple password protected workbooks | Excel Programming | |||
Macro to Open and Compile Multiple Worksheets that are password protected | Excel Programming |