Excel VBA open with Password

  • Thread starter Thread starter jlclyde
  • Start date Start date
J

jlclyde

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
 
Hi
Workbooks.open "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls",
Password:="Monkey"

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

regards
Paul
Click to expand...

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
 
Check your other post.
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
Click to expand...
 
Back
Top