Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 14th 07, 07:54 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 2
Default 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


  #2   Report Post  
Old March 14th 07, 10:18 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 2
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i profile a survey? Paul Excel Worksheet Functions 1 September 18th 06 05:54 PM
How do I email an Excel worksheet? Do I have to create a profile? desertmamma New Users to Excel 1 December 30th 05 12:53 PM
Profile effecting Excel Spike Excel Discussion (Misc queries) 2 November 23rd 05 05:18 PM
links in cells break and revert to user profile location heathy Excel Discussion (Misc queries) 0 October 24th 05 05:37 PM
How do I get Excel to use my normal Outlook profile when emailing Ericthesailor Excel Discussion (Misc queries) 0 September 8th 05 10:54 AM


All times are GMT +1. The time now is 09:41 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017