Need to see if your shared folder is taking up space on your dropbox 👨‍💻? Find out how to check here.

Forum Discussion

YasserKhalil's avatar
YasserKhalil
New member | Level 2
9 years ago

Get files link using excel vba

Hello everyone

I am seeking for a VBA code to get the links of the files and folders in the dropbox 

After doing some searches I have found myself in API solution but have no idea how to do that

Can you guide me please?

6 Replies

  • Greg-DB's avatar
    Greg-DB
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    9 years ago

    We don't have any resources for VBA in particular unfortunately.

     

    In general, we recommend developers use one of the official SDKs, if possible, or if not, one of the community SDKs, or call the HTTPS endpoints directly. 

     

    For example, to create a shared link for any file or folder, you would use the /2/sharing/create_shared_link_with_settings endpoint. If a shared link already exists, you would use /2/sharing/list_shared_links to retrieve it.

  • YasserKhalil's avatar
    YasserKhalil
    New member | Level 2
    9 years ago

    Thanks a lot for reply

    So there is no way using API to do such tasks .. or even similar tasks

    I need the technique of using API in excel VBA .. May be I can finish it up if I have start point 

  • Greg-DB's avatar
    Greg-DB
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    9 years ago
    The API does offer the ability to create and retrieve shared links for files and folders, using the endpoints I linked to in my previous reply.

    Please try using those and let us know if you run in to any issues.
  • YasserKhalil's avatar
    YasserKhalil
    New member | Level 2
    9 years ago

    In fact I already have  a look at those links and tried to make use of it but I couldn't at all

    If you can help me with that, I would appreciate that a lot

     

    Give me code example of how to use API in the excel VBA .. and I will try to study it to make use of it

  • Greg-DB's avatar
    Greg-DB
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    9 years ago
    I don't have a sample for VBA unfortunately. If you can't use an SDK/library, I recommend translating the curl examples in the documentation for whatever HTTP client you can use in your app.
  • YasserKhalil's avatar
    YasserKhalil
    New member | Level 2
    9 years ago

    Thanks a lot anyway for your response .. I will try and if I could reach a solution I will post it here

    Regards

About Dropbox API Support & Feedback

Node avatar for Dropbox API Support & Feedback
Find help with the Dropbox API from other developers.

The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X, Facebook or Instagram.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!