I wrote a home-made Common Dialog Box for VBA, but I'm wondering if there's a way to grab the current Windows username in VBA. I want it for a shortcut to My Documents, as in:
ChDir "C:\Documents and Settings\" & UserName & "\My Documents" Any ideas? -Tim
