Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel VBA open with Password
I have a file that I have changed the options to ask for password to
modify. But anyone can open the file as read only. I want to make changes with a macro to eliminate human error. I want the workbook to be protected but I need the code to open the file so it can make changes. How is this accomplished? I tried but this is if it has a password to open. Workbooks.Open "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls", Password:="Jay" Thanks in advance, Jay |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel VBA open with Password
Try using: writerespassword:="Jay"
Workbooks.Open "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls", writerespassword:="Jay" jlclyde wrote: I have a file that I have changed the options to ask for password to modify. But anyone can open the file as read only. I want to make changes with a macro to eliminate human error. I want the workbook to be protected but I need the code to open the file so it can make changes. How is this accomplished? I tried but this is if it has a password to open. Workbooks.Open "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls", Password:="Jay" Thanks in advance, Jay -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel VBA open with Password
On Apr 28, 11:02*am, Dave Peterson wrote:
Try using: writerespassword:="Jay" Workbooks.Open "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls", writerespassword:="Jay" jlclyde wrote: I have a file that I have changed the options to ask for password to modify. *But anyone can open the file as read only. *I want to make changes with a macro to eliminate human error. *I want the workbook to be protected but I need the code to open the file so it can make changes. *How is this accomplished? *I tried but this is if it has a password to open. Workbooks.Open "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls", Password:="Jay" Thanks in advance, Jay -- Dave Peterson dave, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel VBA open with Password
On Apr 28, 11:02*am, Dave Peterson wrote:
Try using: writerespassword:="Jay" Workbooks.Open "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls", writerespassword:="Jay" jlclyde wrote: I have a file that I have changed the options to ask for password to modify. *But anyone can open the file as read only. *I want to make changes with a macro to eliminate human error. *I want the workbook to be protected but I need the code to open the file so it can make changes. *How is this accomplished? *I tried but this is if it has a password to open. Workbooks.Open "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls", Password:="Jay" Thanks in advance, Jay -- Dave Peterson Dave, Thank you for your keen insight. That fixed it nicely. Do you work for google? If this is your job, how does one go about getting it? Thanks, Jay |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel VBA open with Password
Nope.
I'm just one of the many volunteers who answer questions in the excel newsgroups. jlclyde wrote: On Apr 28, 11:02 am, Dave Peterson wrote: Try using: writerespassword:="Jay" Workbooks.Open "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls", writerespassword:="Jay" jlclyde wrote: I have a file that I have changed the options to ask for password to modify. But anyone can open the file as read only. I want to make changes with a macro to eliminate human error. I want the workbook to be protected but I need the code to open the file so it can make changes. How is this accomplished? I tried but this is if it has a password to open. Workbooks.Open "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls", Password:="Jay" Thanks in advance, Jay -- Dave Peterson Dave, Thank you for your keen insight. That fixed it nicely. Do you work for google? If this is your job, how does one go about getting it? Thanks, Jay -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forgotten OPEN password for Excel file??? | Excel Discussion (Misc queries) | |||
How to open Excel spreadsheet when forgotten password | Excel Discussion (Misc queries) | |||
I Lost my excel password How can I open it? | Excel Discussion (Misc queries) | |||
I Lost my excel password How can I open it? | Excel Discussion (Misc queries) | |||
Excel won't open it's a blank page, after password | Excel Discussion (Misc queries) |