| 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. |
| 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 | |||
Threaded Mode
