tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,210
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I have a problem with dropbox
we have a number of users that have access to my dropbox account but i'm getting problems with them opening other documents in dropbox using VBA with my filepath.
the code "
I have a problem with dropbox
we have a number of users that have access to my dropbox account but i'm getting problems with them opening other documents in dropbox using VBA with my filepath.
the code "
Environ$("UserProfile")"
and the first part "
and the first part "
Fold1 = "Dropbox (ALL)" " work great.
but for some reason Dropbox can give different file paths to the same Document.
for example
Mine is
Environ$("UserProfile")\but for some reason Dropbox can give different file paths to the same Document.
for example
Mine is
Dropbox (ALL)\
Admin\
Caps\Master File.xlsm
but this does not work for others.
so I was wondering, is there a way to say "Find this Document" I whatever folder its in or where it is in my dropbox?
there will only ever be one Document with at name?
Please help with any suggestions as at the moment everytime we add a new user I have to add a new filepath.
below is the code i'm using fir me but I'm happy to try any ideas?
thanks
Tony
but this does not work for others.
so I was wondering, is there a way to say "Find this Document" I whatever folder its in or where it is in my dropbox?
there will only ever be one Document with at name?
Please help with any suggestions as at the moment everytime we add a new user I have to add a new filepath.
below is the code i'm using fir me but I'm happy to try any ideas?
thanks
Tony
Code:
Sub Example_open1()
Fold1 = "Dropbox (ALL)"
Fold2 = "Admin"
Fold3 = "Caps"
WBName = "Master File"
Folds = Fold1 & "\" & Fold2 & "\" & Fold3 & WBName
fd = Environ$("UserProfile") & "\" & Folds & ".xlsm"
Workbooks.Open (fd)
End Sub