Identify Windows Profile

M

MrAngles

Is there a way for VBA to identify what Windows profile the user is
logged in under? I would like to make a macro that will save a macro
into the user's C:\Documents and Settings\<Windows Profile Name>
\Application Data\Microsoft\Excel\XLSTART folder, and to do that I
would need to identify the curent user's folder in Documents and
Settings.

Thank you
 
M

MrAngles

I figured it out, for anyone else interested in this, the
Application.StartupPath property will give the pathing to the current
user's XLSTART folder.
 
Top