Hi Harald,

Yeah, I too was surprised when I read that code somewhere. Was about to
post a "That's not going to work when I tested it. To my suprise, it
worked just fine."

I guess outside of the two suggestions I provided, the only other choice
for the OP would be to use the appropriate Windows API to get the user
name and go from there.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
lid says...
Hi Tushar

Not here they do, norwegian WinXP, various Excel versions. So at best it's
an unstable solution for use in controlled environments. Environ works well
(but not in the 9x windows family).

Best wishes Harald

"Tushar Mehta" skrev i melding
om...
Hi Harald,

XL (or is it Win XP?) correctly expands c:My Documents (when used with
no intervening reverse-slash).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions