| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Include password in formula that links to a protected excel file
I have a master spreadsheet that links to other spreadsheets with passwords.
I want to write the password in the formula that links to the other spreadsheets in order to avoid entering the password manually each time when prompt by excel for the passwords of my links. Thanks, Pat. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Include password in formula that links to a protected excel file
You never said which password so i've assumed password to open.
Sub liminaladvertising() Path = "C:\" fname = "Testbook.xls" Pass = "mypass" Set mybook = Workbooks.Open(Path & fname, Password:=Pass) End Sub Mike "PR2000" wrote: I have a master spreadsheet that links to other spreadsheets with passwords. I want to write the password in the formula that links to the other spreadsheets in order to avoid entering the password manually each time when prompt by excel for the passwords of my links. Thanks, Pat. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel does nothing when I double-click on password protected file | Excel Discussion (Misc queries) | |||
| Recovery of a password-protected excel 2003 file | Excel Discussion (Misc queries) | |||
| Links to password protected workbooks | Excel Discussion (Misc queries) | |||
| how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
| bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
Linear Mode
