Username - Application.username, etc

U

UHsoccer

Well-known Member
Joined
Apr 3, 2002
Messages
1,023
There are several ways to get what appears to give the same answer

Code: 
    Set WSH = CreateObject("Wscript.Network")

    UserWSH = WSH.UserName
    UserApp = Application.UserName
    UserEnv = Environ("username")

Say my name is Joe Smith
I have seen the "username" in the following directory

C:\Documents and Settings\username\Local Settings\Temp

as "jsmith" as well as "Joe Smih"

Any explanation and which one would always get me to that temp directory?
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Sort by date Sort by votes
You could use:
Code: 
ChDir "C:\Documents and Settings\username\Local Settings\Temp"
to change to that directory.
 
Upvote 0
Application.Username will give you the Product License user name (i.e Joe Smith). Environ("username") will give you the current system user name (i.e. jsmith).

So you'd probably want to use the second one. Make sure to use a LCase or UCase argument though. For example I can logon to my PC with either "CSmith" or "csmith", but my Doc & Settings folder is "CSmith".

HTH,

Smitty
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
Autofilter code based on username
Replies
1
Views
188
aabrazil1
A
M
  • Question
Remove one line above after each table pasted from Excel to Word
Replies
0
Views
652
mrwad
M
K
  • Question
Save to PDF and attach to mail
Replies
1
Views
412
wideboydixon
wideboydixon
C
  • Question
Click a cell to Open email msg template and add cell content to Subject field in Outlook
Replies
0
Views
254
Csmith2303
C
O
  • Question
How do I clear or remove a JAVASCRIPT Alert message box in the InternetExplorer.Application Object?
Replies
1
Views
3K
Odd Job 007
O

Forum statistics

Threads
1,215,596
Messages
6,125,728
Members
449,255
Latest member
whatdoido

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top