Obtaining full name in VBA

[reveriedax]

How can I obtain the first and last name of the logged in user from
within VBA. I know that Environ("Username") will give the username,
but there is no such entry for the users full name.

Thanks,
~ d

 

[Dr. Stephan Kassanke]

How can I obtain the first and last name of the logged in user from
within VBA. I know that Environ("Username") will give the username,
but there is no such entry for the users full name.

Thanks,
~ d

http://www.mvps.org/access/api/api0066.htm (Get full name of the user
currently logged in to the system) should help you.

cheers,
Stephan

 

[Jonathan West]

How can I obtain the first and last name of the logged in user from
within VBA. I know that Environ("Username") will give the username,
but there is no such entry for the users full name.

Thanks,
~ d

How to get the username of the current user
http://www.word.mvps.org/FAQs/MacrosVBA/GetCurUserName.htm

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org