How to find file location that my coworker can access

[Sunshine_9787]

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?

[Walter]

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!

[Sunshine_9787]

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 · Accepted solution]

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:

• https://support.microsoft.com/en-us/help/328440/description-of-link-management-and-storage-in-excel

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!