Hi,

I will be giving a spreadsheet that contains a file save option in i
to a few users.

Is there a way that I can get their default file path
(i.e. c:\documents and settings\user1\...)

The user name will change form user1 to a net id like kzcbtw

Once I know what the defualt is I can use MkDir to creat
thedirectories.

Regards
Bria

--
wardide
-----------------------------------------------------------------------
wardides's Profile: http://www.excelforum.com/member.php...fo&userid=1502
View this thread: http://www.excelforum.com/showthread.php?threadid=31492