no, but you can access the value of the variable and build the string
yourself.

sStr = Environ("Userprofile")

for example:
? environ("Userprofile")
C:\Documents and Settings\ogilvtw

so you could use something like
sStr1 = Environ("Userprofile") & "\abcd"

--
Regards,
Tom Ogilvy


"CJH" wrote in message
...
gIs it possible to store environment variables as part of the path to
Linked
Workbooks and allow excel to substitute them when evaluating the links?