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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Range.Find problem 3
Change File Access Question 1
Macro to open a workbook as read only 2
type mismatch error in macro in excel 0
VBA Pivot Table: Determining item from one field based on anotherfield item 0
Problem with existing workbook with macros 4
formula R square 3
Exporting from Excel to Access DB 2

Top