Can't say for getting the username, but to see if the file is opened by a
user on another computer:
http://support.microsoft.com?kbid=138621
XL: Macro Code to Check Whether a File Is Already Open
http://support.microsoft.com?kbid=291295
XL2002: Macro Code to Check Whether a File Is Already Open
http://support.microsoft.com?kbid=213383
XL2000: Macro Code to Check Whether a File Is Already Open
http://support.microsoft.com?kbid=184982
WD97: VBA Function to Check If File or Document Is Open
--
Regards,
Tom Ogilvy
"qq1868" wrote in message
...
macro to find if the Excel file is using by other user and show
the user name?