How do I extract the 'user' name?

[cheoksoon]

Hi everybody,

I've got a shared excel file and sometimes excel displays message box saying:

"excel_file.xlsm is locked for editing by 'Homer Simpson' Open read only or click notify."

Usually I'd click on the 'read only' button. But is there a way I could extract the name of the user editing file from excel VBA? (i.e. Homer Simpson).

I want to incorporate that into a script I've written.

Thanks...

 

[mole999]

something like ENVIRONS(USER)

 

[cheoksoon]

something like ENVIRONS(USER)

Thanks mole999! That was easy. lol.