Default Directories

[wardides]

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

 

[Ron de Bruin]

Hi wardides

Use this
MsgBox Application.DefaultFilePath