| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
| XCEL FILE REC'D AS READ ONLY -- HOW TO NOT BE "READ ONLY" | Excel Discussion (Misc queries) | |||
| Pasword protected Excel file encrypted, how do I read this file? | Excel Discussion (Misc queries) | |||
| How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
| "Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
Hybrid Mode
