Is this possible, or more conveniently changing the read-only status of the existing file. Close and delete the original Assumptions.xls in the same code (the file we opened in step 1.) Microsoft Office/Opening a Word File as Read Only Open a file as read only with the main menu Open a file as read only from Windows Explorer with Shift key. When one of my MAC users has the file open, I too, receive the locked by. Assumptions_ modified.xls in the same directory.Ĥ. Excel will not allow me to open the sheet unless its in read-only mode. I don't mind saving over the existing version once the changes are made, for example:ģ. Is there a way around this problem, I would like to make the change and save over the existing read-only file with the modifications made in the code. It unfortunately comes up with a pop up error that says:Ĭlick 'Notify' to open a read-only copy of the document and receive notification of the document when it is no longer in use.
Set wb = Workbooks.Open('S:\Client\Assumptions.xls', UpdateLinks:=0, ReadOnly:=False) Interesting, I actually tried that method as follows for testing (I was away for a little while so couldn't post earlier).
