We're making changes to the Community, so you may have received some notifications - thanks for your patience and welcome back. Learn more here.
Forum Discussion
How to find file location that my coworker can access
How do I find a file location that allows my coworker using his computer to access the file? For example, the file location from my end is C:\Users\... My coworker cannot access the file because the location is from my comptuer. Is there a path where both of us can access the file?
In that case, I'd suggest using wildcards like %HOMEPATH% Sunshine_9787!
Note that when your workbook is downloaded onto another's computer, the locations that your formula points to are no longer there. The link in the workbook is looking for a specific place, for example /Your_Computer/Your_User/File, and that location is no longer accessible from a different computer.
To learn more about relative and external paths in Excel please consult the following Microsoft support page:
While we are unable to support you in configuring Microsoft Excel to work the way you would like, we usually suggest using wildcards in your formulas. Wildcards, such as "%HOMEPATH%”, if other users have the Dropbox folder located in the default location (the C drive for example), would let you point to a location without having to worry about different usernames in the path.
I hope this helps!
- Walter
Dropbox Staff
Hi Sunshine_9787; welcome to our Community!
I'm not sure what you're trying to accomplish and what exactly is not working for you; could you elaborate on this please?
Thanks!
I am writing a VBA code to open a closed Excel file. The code includes the file path from my computer: Workbooks.Open("C:\Users\Dropbox...
I can only run the code from my computer so my question is there a file path from Dropbox so that my coworker can also run the code from his computer?
- Walter
In that case, I'd suggest using wildcards like %HOMEPATH% Sunshine_9787!
Note that when your workbook is downloaded onto another's computer, the locations that your formula points to are no longer there. The link in the workbook is looking for a specific place, for example /Your_Computer/Your_User/File, and that location is no longer accessible from a different computer.
To learn more about relative and external paths in Excel please consult the following Microsoft support page:
While we are unable to support you in configuring Microsoft Excel to work the way you would like, we usually suggest using wildcards in your formulas. Wildcards, such as "%HOMEPATH%”, if other users have the Dropbox folder located in the default location (the C drive for example), would let you point to a location without having to worry about different usernames in the path.
I hope this helps!
