Read Only File
 

Hi,
I want to open an XL file which is saved as read only as part of a macro,
(all above board, its my file). I know the code to open it but it still
gives the promt for the password. This is on a networked system, the file in
question is on a public drive.
Workbooks.Open Filename:="\\P:\Statistics$\Files\DA\BB29.xls"
Is there a way to incorporate the password within the code so it just opens
the file in the same way as unprotecting a worksheet like
Sheet2.Unprotect ("Password")
Something like
Workbooks.Open Filename:="\\P:\Statistics$\Files\DA\BB29.xls", Password:=
("Password")
That doesnt work, I've tried it!
Thanks for any advice,
Regards,
Alan.

Read Only File
 

Sorry those two lines have turned into hyperlinks, I don't know why that
happened, it wasn't like that when I sent it, please ignore them,
Regards,
Alan.
"Alan" wrote in message
...
Hi,
I want to open an XL file which is saved as read only as part of a macro,
(all above board, its my file). I know the code to open it but it still
gives the promt for the password. This is on a networked system, the file
in question is on a public drive.
Workbooks.Open Filename:="\\P:\Statistics$\Files\DA\BB29.xls"
Is there a way to incorporate the password within the code so it just
opens the file in the same way as unprotecting a worksheet like
Sheet2.Unprotect ("Password")
Something like
Workbooks.Open Filename:="\\P:\Statistics$\Files\DA\BB29.xls", Password:=
("Password")
That doesnt work, I've tried it!
Thanks for any advice,
Regards,
Alan.

Read Only File
 

Workbooks.Open FileName:= fName, Password:= PW
--
Tim Williams
Palo Alto, CA


"Alan" wrote in message ...
Sorry those two lines have turned into hyperlinks, I don't know why that
happened, it wasn't like that when I sent it, please ignore them,
Regards,
Alan.
"Alan" wrote in message
...
Hi,
I want to open an XL file which is saved as read only as part of a macro,
(all above board, its my file). I know the code to open it but it still
gives the promt for the password. This is on a networked system, the file
in question is on a public drive.
Workbooks.Open Filename:="\\P:\Statistics$\Files\DA\BB29.xls"
Is there a way to incorporate the password within the code so it just
opens the file in the same way as unprotecting a worksheet like
Sheet2.Unprotect ("Password")
Something like
Workbooks.Open Filename:="\\P:\Statistics$\Files\DA\BB29.xls", Password:=
("Password")
That doesnt work, I've tried it!
Thanks for any advice,
Regards,
Alan.

Read Only File
 

Sorry but I can't get that to work, its the same as in my post isn't it, or
am I missing something?
Regards,
Alan.
"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
Workbooks.Open FileName:= fName, Password:= PW
--
Tim Williams
Palo Alto, CA


"Alan" wrote in message
...
Sorry those two lines have turned into hyperlinks, I don't know why that
happened, it wasn't like that when I sent it, please ignore them,
Regards,
Alan.
"Alan" wrote in message
...
Hi,
I want to open an XL file which is saved as read only as part of a
macro,
(all above board, its my file). I know the code to open it but it still
gives the promt for the password. This is on a networked system, the
file
in question is on a public drive.
Workbooks.Open Filename:="\\P:\Statistics$\Files\DA\BB29.xls"
Is there a way to incorporate the password within the code so it just
opens the file in the same way as unprotecting a worksheet like
Sheet2.Unprotect ("Password")
Something like
Workbooks.Open Filename:="\\P:\Statistics$\Files\DA\BB29.xls",
Password:=
("Password")
That doesnt work, I've tried it!
Thanks for any advice,
Regards,
Alan.

Read Only File
 

Not *exactly* the same, which is why I posted it.
It's always worked for me.

Excel version etc?

Tim


"Alan" wrote in message ...
Sorry but I can't get that to work, its the same as in my post isn't it, or am I missing something?
Regards,
Alan.
"Tim Williams" <timjwilliams at gmail dot com wrote in message ...
Workbooks.Open FileName:= fName, Password:= PW
--
Tim Williams
Palo Alto, CA


"Alan" wrote in message ...
Sorry those two lines have turned into hyperlinks, I don't know why that
happened, it wasn't like that when I sent it, please ignore them,
Regards,
Alan.
"Alan" wrote in message
...
Hi,
I want to open an XL file which is saved as read only as part of a macro,
(all above board, its my file). I know the code to open it but it still
gives the promt for the password. This is on a networked system, the file
in question is on a public drive.
Workbooks.Open Filename:="\\P:\Statistics$\Files\DA\BB29.xls"
Is there a way to incorporate the password within the code so it just
opens the file in the same way as unprotecting a worksheet like
Sheet2.Unprotect ("Password")
Something like
Workbooks.Open Filename:="\\P:\Statistics$\Files\DA\BB29.xls", Password:=
("Password")
That doesnt work, I've tried it!
Thanks for any advice,
Regards,
Alan.