Excel VBA open with Password
 

I am trying to write code to open a file that has a known password.
Coudl you help me over this hurdle? Here is the file path and
password.
Name and path = "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls"
Password = "Monkey"

Thanks,
Jay

Excel VBA open with Password
 

Hi
Workbooks.open "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls",
Password:="Monkey"

regards
Paul

Excel VBA open with Password
 

On Apr 28, 9:37*am, wrote:
Hi
Workbooks.open "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls",
Password:="Monkey"

regards
Paul

Paul,
I am sorry I did not explain this very well. I ahve the workbook in
question password protected to make changes not to open. Anyone can
open the file, but you need a password to modify or make changes. I
want the macr to do all of the changes to the sheet to eliminate human
error. How do you do this?

Thanks in advance,
Jay

Excel VBA open with Password
 

Check your other post.

jlclyde wrote:

I am trying to write code to open a file that has a known password.
Coudl you help me over this hurdle? Here is the file path and
password.
Name and path = "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls"
Password = "Monkey"

Thanks,
Jay

--

Dave Peterson