Excel Macro to track username when file opened? 1

[bdmangum]

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!

 

[PHV]

A starting point:
MsgBox Environ("USERNAME")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bdmangum]

Thanks PHV! That should be all I need, the rest of the coding shouldn't be difficult. Never knew the Environ even existed.

thanks!