I am writing VBA code to open a closed workbook.
I can only run this code using my computer. Is there a way I can run this code using another computer?Please Login or Register to view this content.
I am writing VBA code to open a closed workbook.
I can only run this code using my computer. Is there a way I can run this code using another computer?Please Login or Register to view this content.
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.
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?
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.
I cannot upload a json file so I uploaded a txt file instead. Thank you for your help.
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.
Thank you so much for your help! It works perfectly.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks