Closing a file in dropbox opened by another collaborator?

Hello

I wonder if we can close a file that is in a shared folder of Dropbox and opened by another collaborator from a different location.For example I am the owner of the file and I want that when I am making changes to a workbook in Dropbox shared folder then all other instances of the same file (that may be opened by other user/collaborator) should be programatically closed. Because I don't want to create a conflicted copy of MY changes.

Separating the question from above description

" Can we close a Dropbox file that is opened by another user from another town? (with VBA)"

Found no solution on the internet. So any help would be greatly appreciated.This is a real pain for me these days.


Best Regards
Imran Bhatti

Hi,

Unless Dropbox provides an API for that, the answer is almost certainly no.

Originally Posted by xlnitwit

Unless Dropbox provides an API for that.

Thanks for the review XlnitWit
I was thinking there might have been a big gun (API) to invade.Any conventional weapon?

I don't believe so. It would be a little worrying if VBA could easily affect files on remote computers.

Thanks Xlnitwit
If I go one step back and want to know just the status of the file in the shared folder. I mean if that file is opened or not. For that purpose I just found a code on the web

Please Login or Register  to view this content.

This works fine for my PC. But if I use this from another PC it says file not found.Would you please review it when you have some time as it would be a complicated one.

Folder path is

"C:\Users\Name of my PC\another folder\Dropbox\Uploads\Database14.accdb"

I do not believe that this approach would work for two reasons. First, it is not the correct approach for an access database, which creates a lock file (.ldb) when opened. Second, the other user has their own local copy of the file open and that copy is then synchronised by Dropbox later. You do not both have the same file open at any point.