| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbook with password in VBA
I have saved several workbooks in a directory that are password protected. Using the following code, How do I tell it to use the password when it opens the file? MyPath is the directory path MyFiles(Fnum) is the workbook name. This is an array of workbook names all using the same password. Set mybook = Workbooks.Open(MyPath & MyFiles(Fnum)) Thanks Shawn G. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open workbook with password in VBA
Try this...
Set mybook = Workbooks.Open(Filename:=MyPath & MyFiles(Fnum), _ Password:="MyPassword") -- HTH... Jim Thomlinson "Shawn G." wrote: I have saved several workbooks in a directory that are password protected. Using the following code, How do I tell it to use the password when it opens the file? MyPath is the directory path MyFiles(Fnum) is the workbook name. This is an array of workbook names all using the same password. Set mybook = Workbooks.Open(MyPath & MyFiles(Fnum)) Thanks Shawn G. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open workbook with password in VBA
Thank You!!! Worked Perfectly!
"Jim Thomlinson" wrote: Try this... Set mybook = Workbooks.Open(Filename:=MyPath & MyFiles(Fnum), _ Password:="MyPassword") -- HTH... Jim Thomlinson "Shawn G." wrote: I have saved several workbooks in a directory that are password protected. Using the following code, How do I tell it to use the password when it opens the file? MyPath is the directory path MyFiles(Fnum) is the workbook name. This is an array of workbook names all using the same password. Set mybook = Workbooks.Open(MyPath & MyFiles(Fnum)) Thanks Shawn G. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Password to open workbook | Excel Discussion (Misc queries) | |||
| I know my password, yet it will not open my workbook | Excel Worksheet Functions | |||
| need to open my workbook not asking for password so i can do so | Excel Discussion (Misc queries) | |||
| Open en close a workbook with password | Excel Programming | |||
| Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
Linear Mode
