Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Macro to track username when file opened? 1

Status
Not open for further replies.

bdmangum

Technical User
Dec 6, 2006
171
US
I work in an office which uses a windows network, and everyone is required to have username. I created a macro based file which is on the network for anyone to use. Is there a way to set the file so it creates a hidden log storing the username and date of those who open the file? Can excel macros work hand in hand with the Windows screenname system?

Thanks in advance!
 
A starting point:
MsgBox Environ("USERNAME")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Thanks PHV! That should be all I need, the rest of the coding shouldn't be difficult. Never knew the Environ even existed.

thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top