When I use the folder path on my computer it works great. However, Dropbox is in slightly different locations on other computers that would need to run the macro. Is there a way to get to the files without modifying the code for ever computer? The only difference in the folder path would be everything up to where Dropbox is in the path and would need to include usernames as below.
Please Login or Register to view this content.
You may try:
Please Login or Register to view this content.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Your original worked, but what happens if there is not a mydocuments in the path on another computer. Why does the code below not work? Dropbox is the only folder that will be the first folder to be consistent in the path.
Please Login or Register to view this content.
Last edited by jh51745; 03-10-2014 at 02:44 PM.
Dropbox is not native Windows folder therefore such code will not work. If folder will jot always be in Documents I think you must check registry.
Is there another way to search for the Dropbox folder regardless of user and location?
I do not know. I have not found folder location in registry.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks