View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Kelly[_3_] Kelly[_3_] is offline
external usenet poster
 
Posts: 8
Default Returning User Initials

Thanks to you both. Your advice did help me to understand
a little better but unfortunaly (or fortunaltley depending
how you look at it) I also now relize the code I build is
not as secure or as reliable as I firt thought.

First of all good advice Jhon but I need all three
initials and it appears company standards were to only
enter the first and last name of the employee when
installing Office.

Secondly I found a way to break into my spreadsheet to
read information that was not meant for me.

See the way I had set it up is that when you opened the
template it would automaticly find the Application .user
and based on this prefor a bunch of V-look ups on a
verryhidden conrtol sheet. Now I realize that the user
only has to change the info in his General options to look
at other users info.

I know that it is not real secure as a hidden sheet but I
think more so then this. Also I did a little testing and
if there is even an extra space in the info under general
options then the v-lookup crashes.

As far as the initals, I just added anonther column to my
hidden sheet and added another v-lookup to access the
initials but I am a little worried about the other issues
now.

Any other suggestions as to how to return PC user
information? I would like to be able to referance the
users Windows log-on ID but have no idea to do that?

Thanks for all your help.

Kelly





-----Original Message-----
Hi all, I am using the Office 2000 package

In Word VB you can return user initials
with "Application.UserInitials"

Is there any way to do this in Excel?

I know you can return user name
with "Application.UserName" but no luck with initials so
far.

Also Where does the user name info come from anyway?
In "Word" it is entered in tools/Options/UserInformation
but I have no idea for Excel.


Thanks as always!

Kelly
.