Using Application.Username you can set or get the current user name. This can
also be accessed via menuToolsGeneralUserName.........whereas 'Environ'
returns a string associated with an OS environment.
If this post helps click Yes
---------------
Jacob Skaria
"leungkong" wrote:
Thanks Stanley,
But I wanna know the difference of Environ("USERNAME") and
application.username
Could you please explain? Many thanks again.
"stanleydgromjr" wrote:
leungkong,
Try:
Retreiving Full Name of User (Not Username) in VBA script
Environ("USERNAME")
This link may help:
'Excel Windows Username'
(http://www.mrexcel.com/archive/VBA/13778.html)
--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115292