Hi,
I am a VBA novice, and putting code together based on what I find online, so any help is really appreciated!
I want to open a document from the shared drive, make some changes to it, save it and close it again. That part I think I have managed, but what I need to do now is to test whether someone else already has it open, and if they do, then exit the macro and display a message. Otherwise it just opens in read only and saves as a copy, and I don't want that to happen.
From looking around in this forum, it seems like I need to use something like:
If Workbooks(PathToFile & "\" & NameOfFile).ReadOnly Then
...but I can't seem to make it work. Do I need to set this to be a variable?
Thank you
Bookmarks