vba - User option in Access to select unique filepath for Excel source data -

i working off of great solution created @matthall 2011 question shared importing dynamic range excel access.

specific that--though in general future vba's--my question whether there additional way able point excel source file if moved without having go vba editor every time?

for specific needs, trying work on these access , excel files others through shared box has different file path whoever working on it.

user 1 may be: c:\users\user1\box sync\filename.xlsx

user 2 may be: c:\users\user2\box sync\filename.xlsx

...and forth other users. curious how can work off when file path used in vba created , used user1 not accessible user2? there code allows every user locate file each time through own filepath?

it pain not know better option not working off shared server , unfortunately limited box share @ moment.

edit: if suggest how integrate recommendation 'dynamic range' code in solution @matthall in linked stackoverflow, particularly helpful request.