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

[qq1868]

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

[Anne Troy]

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" <[email protected]> wrote in message
news:[email protected]...
> macro to find if the Excel file is using by other user and show
> the user name?

[Tom Ogilvy]

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" <[email protected]> wrote in message
news:[email protected]...
> macro to find if the Excel file is using by other user and show
> the user name?