| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba macro open password protected workbook
How do I get a Macro to open a password protected workbook without prompting
the user for it? I have several users writing to the same file via macros but I want to keep their information private from each other. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba macro open password protected workbook
Just pass the password as an argument the same as you do with the wb path and
name. Something like this: Workbooks.Open ThisWorkbook.Path & "\gregtest.xls", Password:="greg" Regards, Greg "Ray" wrote: How do I get a Macro to open a password protected workbook without prompting the user for it? I have several users writing to the same file via macros but I want to keep their information private from each other. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba macro open password protected workbook
If you press F1 on the word 'open', the help system will also tell you about
various other choices, such as update links, and read only. (If the help has been installed OK!) "Greg Wilson" wrote: Just pass the password as an argument the same as you do with the wb path and name. Something like this: Workbooks.Open ThisWorkbook.Path & "\gregtest.xls", Password:="greg" Regards, Greg "Ray" wrote: How do I get a Macro to open a password protected workbook without prompting the user for it? I have several users writing to the same file via macros but I want to keep their information private from each other. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel macro to open a password protected workbook | Excel Discussion (Misc queries) | |||
| Make Workbook Password protected tp open | Excel Discussion (Misc queries) | |||
| Open workbook that is protected with password | Excel Programming | |||
| Open password protected workbook. | Excel Programming | |||
| Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
Linear Mode
