I have an Excel spreadsheet which will be used by many users across our network. I would like to have the spreadsheet save to a user's My Documents folder in Windows 2000 (C:\Documents and Settings\"UserName"\My Documents). The "UserName" is the person's network ID, the folder being set up when they initially log on to the Network. Is there any way inside an Excel macro that I can get this Network ID/User name? I tried Application.UserName but that seems to return the generic computer owner, and not the name of the person logged on to the Network. Once I have the Network ID I can put that variable in the file save path so all users can use the same spreadsheet to do their saves

Thanks!