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 "C:\Users*Username*\root\directory\TTTT.xlsx"
How I can use a unic path? Thanks for your answer
Hello @Flor,
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".
keepafter()
system("user")
@dgudkov thanks a lot I will test.