View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michel Pierron[_2_] Michel Pierron[_2_] is offline
external usenet poster
 
Posts: 63
Default How to get Name of person signed on Computer

Hi CLR,
One way:
..LeftFooter = "Printed by: " & CreateObject("WScript.Network").UserName

MP

"CLR" a écrit dans le message de
...
Hi All...........

This is my code, retrieved from kind souls in these groups.

With wkSht.PageSetup
.CenterFooter = ActiveWorkbook.FullName
.RightFooter = "Rev-L " & Range("DateSecret").Value
.LeftFooter = "Printed by: " & Application.UserName
End With

It all works fine, except for the "UserName" part. My intentions were to
retrieve the name of the person who signed on the computer, but this code
returns the name of the person that this computer's Excel was Installed to.
May this code be modified, or is there some other way to make it print out
who the Computer User is?

Many thanks in advance.....

Vaya con Dios,
Chuck, CABGx3