Using API from Excel VBA

In that case, if your app will only be connecting to your own account, you don't need to implement the OAuth app authorization flow at all.

For reference, the API was designed with the intention that each user would link their own Dropbox account, in order to interact with their own files. However, it is technically possible to connect to just one account. The SDKs don't offer explicit support for it and we don't recommend doing so, for various technical and security reasons.

However if you did want to go this route, instead of kicking off the authorization flow, you would manually use an existing access token for your account and app. (Just be careful not to revoke it, e.g. via https://www.dropbox.com/account/security .) For example, you can generate an access token for your account via your app's page on the App Console.

If you have a shared link that you want to get information about programmatically you can use /metadata/link.