Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem changing open file from R/0 to R/W
I am trying to change a file that has been saved R/O to R/W, mak
changes to the file and then save as R/O again. I get the macro to open the file and have tried: ActiveWorkbook.ChangeFileAccess xlReadWrite But I then get a message saying file is locked for editing by anothe user. How can I get round this? Also if I start with the file R/W and change to R/O (wit ActiveWorkbook.ChangeFileAccess xlReadOnly), when I try to save it, i asks me to save as another name. How can I save it as the same name? Any help would be greatly appreciated. I'm sure there is something ver obvious that I'm missing -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem changing file associations in Excel 2007 | Excel Discussion (Misc queries) | |||
Open excel file problem | Excel Discussion (Misc queries) | |||
I got a problem when tried to open the file! | Excel Discussion (Misc queries) | |||
cannot open documents as viruscan says problem file? | Excel Discussion (Misc queries) | |||
Open delimited text file to excel without changing data in that file | Excel Programming |