Retrieve link to dropbox folder in VBA

Paul T.42

Using VBA (Access) I have automated copying a bunch of folders and files into a Dropbox folder. This process is repeated for several people (with different source folders and files) and I would really like to complete the automation by creating a standard email with a link to the Dropbox folder just created for them. At the moment I am using the Share - Send Link function in Dropbox to obtain the dropbox.com address of the folder which I then copy into the email. IS there a way that I can grab the link information in VBA so that the process can be fully automated?

Steve M.

I'm not that familiar with VBA, but I think this should be possible. The https://www.dropbox.com/developers/core/docs#shares endpoint will give you the same kind of link as "Share - Send Link" in Dropbox itself.

Before you can call that, you'll need to create an API app and get an access token for the user who owns the Dropbox account. You might want to take a look at one of the tutorials for the https://www.dropbox.com/developers/core to get started.