VBA Changing Directory for different users

[Camel_Rider]

Hello there!
I've only recently started learning VBA and wanted to know if there was a way to have the directory change for different users. I have a basic excel VBA macro which performs the function of importing data. I want to share it with my colleagues but they have to manually change the code for the users name and to fit their file addresses. Was wondering if there was a way to have this automated.
Thank you in advance!

 

[JEC]

Are you using sharepoint? If so, use the complete sharepoint path and make sure everyone has access to that file.