Excel 2010 VBA code to determine username of open file on network

Code that gives logged in username is known as is code to determine whether file is open but what I need is the username of the open file - need to know users login to send email to hrequest they release file.

THe answer is not application.username and it is not application.writereservedby

So you want to list usernames using a shared workbook?

Please Login or Register  to view this content.