macro to find if the Excel file is using by other user
 

macro to find if the Excel file is using by other user and show
the user name?

macro to find if the Excel file is using by other user
 

Maybe this will get you started:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=443
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"qq1868" wrote in message
...
macro to find if the Excel file is using by other user and show
the user name?

macro to find if the Excel file is using by other user
 

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?