| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access to password protected workbook
I have a password protected workbook (DataFile.xls) that I want to access
from File1.xls using a VLOOKUP function. When the user opens the File1.xls I can avoid the update links by adding this line to an beforeworkbookopen event: Workbooks.Open Filename:= "File1.xls", UpdateLinks:=3 But then the user gets prompted to enter the password. Is it possible to use the beforeworkbookopen event to input the password. I don't want the password entry to be manual. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Obtaining access to protected files you dont know password for | Excel Discussion (Misc queries) | |||
| How to access protected spreadsheet without the password? | Excel Discussion (Misc queries) | |||
| Unprotecting password protected workbook | Excel Discussion (Misc queries) | |||
| How to import data from a password protected Access DB into Excel. | Excel Discussion (Misc queries) | |||
| Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) | |||
Hybrid Mode
