+ Reply to Thread
Results 1 to 8 of 8

Dropbox file path shared with other computers

  1. #1
    Registered User
    Join Date
    04-20-2020
    Location
    Vancouver
    MS-Off Ver
    2010
    Posts
    7

    Dropbox file path shared with other computers

    I am writing VBA code to open a closed workbook.

    Please Login or Register  to view this content.
    I can only run this code using my computer. Is there a way I can run this code using another computer?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Dropbox file path shared with other computers

    Dropbox puts a JSON file on your hard drive that gives the path used by Dropbox. Most people probably just use the default but you can change it. It looks like you changed yours; normally it would be down one more level

    C:\Users\eugene_9787\Dropbox\

    This function will return the path, which you can incorporate into your existing code:

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    04-20-2020
    Location
    Vancouver
    MS-Off Ver
    2010
    Posts
    7

    Re: Dropbox file path shared with other computers

    Thank you for your help! I have a Dropbox personal and business account. The file is located in the business account. When I tested the code, it was searching my personal account. In this case, how would this issued be solved?

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Dropbox file path shared with other computers

    There would be multiple lines in the JSON file but I don't know what that looks like, since my situation is not the same. Can you attach your JSON file for a look? Check here:

    C:\Users\Jeff\AppData\Local\Dropbox\info.json

    Use your name on your computer where I showed Jeff. Note that AppData is a hidden folder. If you don't have Windows Explorer configured to show hidden folders you will have to update it.

    If it's not there then open a cmd window and type

    echo %LOCALAPPDATA%

    to see where the folder is.

  5. #5
    Registered User
    Join Date
    04-20-2020
    Location
    Vancouver
    MS-Off Ver
    2010
    Posts
    7

    Re: Dropbox file path shared with other computers

    I cannot upload a json file so I uploaded a txt file instead. Thank you for your help.
    Attached Files Attached Files

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Dropbox file path shared with other computers

    Here is a quick and dirty fix that will work to extract only the business path. A more elegant version would ask you which one you want to use:
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    04-20-2020
    Location
    Vancouver
    MS-Off Ver
    2010
    Posts
    7

    Re: Dropbox file path shared with other computers

    Thank you so much for your help! It works perfectly.

  8. #8
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Dropbox file path shared with other computers

    You're welcome! Glad I could help.

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA to get directory using dropBox shared link
    By excelkaaccount in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-10-2020, 06:30 AM
  2. VBA Code to Copy a folder Template on a shared dropbox
    By Subtotalatom in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2020, 07:24 AM
  3. Relative path with Dropbox
    By emlynot in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-16-2018, 03:36 PM
  4. Search for the file name is dropbox path and list the link
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2017, 04:07 AM
  5. Excel VBA Code to upload a file to Dropbox using the Dropbox API
    By gb# in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2014, 03:41 PM
  6. Access DB on shared folder (SharePoint/SkyDrive/DropBox)
    By kvam123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-31-2013, 11:24 AM
  7. Issues with many .xlsx files saved in a shared dropbox
    By vin.napoli in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 10-12-2012, 06:23 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1