Consulting

Results 1 to 3 of 3

Thread: Get email address of the user log from excel vba

  1. #1
    VBAX Regular naris's Avatar
    Joined
    Jul 2008
    Posts
    34
    Location

    Smile Get email address of the user log from excel vba

    I want write in cell A1 with a email address of the user who have log in the PC.

    please, could you let me know the macro to do it ? ..

    Thanks,
    Naris

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    You can get the username. How that relates to their email address is something that you have to "lookup".

    [VBA]Sub Test
    Range("A1").Value=Environ("username")[/VBA]

  3. #3
    VBAX Regular naris's Avatar
    Joined
    Jul 2008
    Posts
    34
    Location
    Thanks you very much

    Naris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •