ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Identify Windows Profile (https://www.excelbanter.com/excel-discussion-misc-queries/134866-identify-windows-profile.html)

MrAngles

Identify Windows Profile
 
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


MrAngles

Identify Windows Profile
 
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.



All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com