Problem changing open file from R/0 to R/W

S

Scampa7

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
 
Top