Child Item

Finding Dropbox status from Excel VBA

I am developing an Excel spreadsheet which is stored on Dropbox (so when complete it can be shared with other users). When the spreadsheet opens I wish to be able to check in VBA code that the file is synchronised before proceeding. I cannot find out how to do this, and you seem to have an API for everything except Windows !!! All I can do so far is to check (using two Windows API functions) is that a) there is a valid internet connection; and b) that I can ping the Dropbox website. Any suggestions ??? Steve

Find more posts tagged with

API

Abuse

Comments

Rich

Moved to the API forum.

Greg-DB

It sounds like you want an API for the official Dropbox desktop client itself, which we currently don't offer. The Dropbox API is designed to talk directly with the Dropbox servers, whether or not the desktop client is installed. I'll be sure to send this along as a request though.

Steve M.

I suppose you could download the latest version via the API and do a file comparison with the one on local disk.

Steve T.7

Thanks for your responses - Apologies for the delay responding, but the monitor on my computer expired so couldn't see any messages etc. for a while. I think I'll carry on as I am for a while in the hope that an API for the Dropbox desktop client will materialise one day...