Hello, I have the xlsx files in a sharepoint, we have a easymorph project that use those files.
Our situation is the path that I use is not the same for my collegues. the username change for each of us
How I can use a unic path?
Thanks for your answer
If you need to dynamically construct a file path with the current Windows username, you can use an expression with the system() function:
"C:\Users\" & keepafter(system("user"), "\") & "\root\directory\TTTT.xlsx"
We need to use
keepafter() here because
system("user") returns the full Windows account name that includes the domain part, e.g. "DOMAIN\Username".
@dgudkov thanks a lot I will test.