Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 221
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro To Open a User selected File Chris Excel Worksheet Functions 2 September 6th 07 08:58 PM
How can second, third user sign excel file containing macro Sevgi Excel Discussion (Misc queries) 0 November 10th 06 03:23 PM
Macro stop if file in use by other user? Bry Excel Discussion (Misc queries) 5 August 11th 06 04:27 PM
Can't find macro in an Excel file to delete it Ron Excel Discussion (Misc queries) 3 July 1st 05 01:07 PM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"