2/16/2023 0 Comments Box vs dropbox locking files![]() The user is asked to reopen the original file and then close it. In the present version, if a user checks-out a file and then uses File Save As to save that file under another name, the file under the new name is checked-out to that user but the original file is not checked-in. You can read the documentation and download the macros at. When the first user completes editing the file and closes it, the Manager's name in the file’s built-in properties is set empty and the file is immediately saved and synchronized through Dropbox thereby checking in the file so someone else can check it out. If another user attempts to open a file that has been checked out to someone else, they will get a message that the file is currently being edited and the name of the other user is displayed. The way the macros work is that when a file is checked-out to a user, that user’s name is stored as "Manager" name in the file’s built-in properties and the revised file is immediately saved and synchronized through Dropbox. They have been designed to work with Office 2003 on PCs and Office 2004 on Macs but have not yet been tested in those environments. ![]() We have been using them on PCs running Office 2010 and Macs running Office 2011. I came up with some simple Visual Basic for Applications (VBA) macros that handle file check-out and check-in. Some of the issues with Notifybox are that it sometimes misses file opens and closes, seems to block reboots on Windows XP, sometimes falsely concludes that there is no active internet connection on that PC even though Dropbox is having no problem synchronizing files, and doesn't run on Macs. Our team used Notifybox for several months to check-out and check-in shared Excel and Word files in Dropbox.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |