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 |
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