Read Only File

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

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.
 
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.
 
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.
 
Not *exactly* the same, which is why I posted it.
It's always worked for me.

Excel version etc?

Tim
 
Back
Top