I use this:
http://www.mvps.org/access/api/api0008.htm
No problems experienced yet but, it is a tad s-l-o-w.
"fastmonkey512"
wrote in message
news:fastmonkey512.231esm_1139614802.2992@excelfor um-nospam.com...
Hi all
I've used a bit of code from the M$ site that grabs the users name
using a windows API
The code is from here http://support.microsoft.com/?kbid=161394
There are about 10 people who all use this spreadsheet and everything
works fine, but on 1 PC it does not get the user name and it doesn't
matter who logs in
Has anyone else used that bit of code before, and seen this happen.
All it seems to do it leave the Var LpName with 256 spaces and no
name.
--
fastmonkey512
------------------------------------------------------------------------
fastmonkey512's Profile:
http://www.excelforum.com/member.php...o&userid=23982
View this thread: http://www.excelforum.com/showthread...hreadid=511253