How to get the username who opened the excel sheet in a network

[vijaykumar.madi]

Hi Everbody,

Could be please help me how to get the username of a person who opened excel sheet in a network.
Every monday i need to update 5 workbooks which sometimes gives me a message as "XYZ" has opened and 3 button options are displayed
"Read Only" , "Notify" and "Cancel".
What i need is the name so that i can keep a mail to the particular user and tell to close the file.

Below is the sample code which i am working on which allways gives my name .

Please Login or Register  to view this content.

Can anybody help me to resolve.
Thanks in Advance Vijay........

[Cutter]

@ vijaykumar.madi

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.