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 kommentar(er)
