Hello.
I've been faced with a problem a couple times now which isn't even listed in MS's help :
I have a bunch of .xlsm files that me and my colleague are working with on a local network folder. (\\folder1\...)
They are not shared workbooks, so naturally only 1 user can open it at a time.
However sometimes when the user opens the file for a long time, another user can open it in readwrite mode, so when someone saves the file, the progress the other user made may be lost.
These files have in common a Worksheet_BeforeSave macro that just does a copy of this workbook in another folder via ThisWorkbook.SaveCopyAs but I don't see why this would be a problem...
I suspected, when the long-time user's PC goes in sleep mode or whatever, the temporary $filename.xlsm (invisible) file gets deleted or Something ?
If anyone that knows well Windows & Excel that could give me any clue on how to solve this I would appreciate.
Thank you for taking the time to read.
Louis
I've been faced with a problem a couple times now which isn't even listed in MS's help :
I have a bunch of .xlsm files that me and my colleague are working with on a local network folder. (\\folder1\...)
They are not shared workbooks, so naturally only 1 user can open it at a time.
However sometimes when the user opens the file for a long time, another user can open it in readwrite mode, so when someone saves the file, the progress the other user made may be lost.
These files have in common a Worksheet_BeforeSave macro that just does a copy of this workbook in another folder via ThisWorkbook.SaveCopyAs but I don't see why this would be a problem...
I suspected, when the long-time user's PC goes in sleep mode or whatever, the temporary $filename.xlsm (invisible) file gets deleted or Something ?
If anyone that knows well Windows & Excel that could give me any clue on how to solve this I would appreciate.
Thank you for taking the time to read.
Louis
Last edited:
