Generic User for Excel Connection String -

is possible have generic user reference in data connection string of excel data connection?

i have external reference workbook share colleagues, , in collaboration software use there path each user's synced folder, such as:

c:\users\"username"\....

is there prompt similar %userprofile% use in instance? here full connection string example:

dsn=excel files;dbq=c:\users\"username"\...\file.xlsx;defaultdir=c:\users\"username"\...;driverid=1046;maxbuffersize=2048;pagetimeout=5;

to generate c:\users\username use: environ("homedrive") & environ("homepath")

To form