| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect if a file is in use or being modified
Anyone know of a formula or vba script to detect if a file is currentl being modified or accessed by another user? -- shaw ----------------------------------------------------------------------- shawb's Profile: http://www.excelforum.com/member.php...fo&userid=1420 View this thread: http://www.excelforum.com/showthread.php?threadid=38275 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Detect if a file is in use or being modified
shawb,
Try to Open it Exclusively. NickHK "shawb" wrote in message ... Anyone know of a formula or vba script to detect if a file is currently being modified or accessed by another user?? -- shawb ------------------------------------------------------------------------ shawb's Profile: http://www.excelforum.com/member.php...o&userid=14204 View this thread: http://www.excelforum.com/showthread...hreadid=382751 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Detect if a file is in use or being modified
Simple VBA test:
From excel, open the file with VBA workbooks.open() with notify = false. After that check if the workbook has been loaded, if not, the file is in use. DM Unseen |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Detect if a file is in use or being modified
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 "shawb" wrote in message ... Anyone know of a formula or vba script to detect if a file is currently being modified or accessed by another user?? -- shawb ------------------------------------------------------------------------ shawb's Profile: http://www.excelforum.com/member.php...o&userid=14204 View this thread: http://www.excelforum.com/showthread...hreadid=382751 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Modified File Organization | Excel Discussion (Misc queries) | |||
| insert the date the file was last modified | Excel Discussion (Misc queries) | |||
| date file modified | Excel Discussion (Misc queries) | |||
| detect if file opens read-only | Excel Programming | |||
| Detect if file is open | Excel Programming | |||
![shawb[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
