Embedding environmental variable into a formula

[dachadster13]

Hey everyone,

I have a document that is used among multiple people that references other Excel files stored locally on their machine. As of right now I need to create different versions for everyone as I have to specify the entire filepath. Naturally we all have different paths as indicated by the username (C:\Users\username\desktop). Here is my formula as is stands currently:

Please Login or Register  to view this content.

I am needing the v-cmeyer to be changed automatically depending on the user who opens it. I have created a module which displays the Windows environmental variable of username but cannot seem to incorporate it into the existing formula. Was wondering if this is even possible or do I need to approach it differently? Any help would be greatly appreciated. Thanks.

[Norie]

Where does the formula display the name?

[dachadster13]

In the filepath is where the formula is supposed to be. Where is says v-cmeyer I need the =Username() variable I created. Sorry for the confusion.

[Norie]

Can you post the code and example formula that uses it?

[dachadster13]

Here is the ENV variable code, which works by itself:

Please Login or Register  to view this content.

Here is where I am trying to apply it.

Please Login or Register  to view this content.

[watersev]

hi dachadster13, it looks it should be sort of that then:

Please Login or Register  to view this content.