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

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

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,

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

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