LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Is workbook open anywhere in network?

Good morning

I have a workbook located on a network directory to which
many users have access.

I am writing additional code to update that wokbook from
time to time.

I want to be able to tell, before any action is taken, if
anyone already has the workbook open, either "read only"
or "read/write"

Is is possisble to do this....and if so can the user who
has it open "read/write" be identified.

The file is not shared.

Using Win2000 and Excel2000

Thanks and regards

Michael Bond

 
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
XL2007 - Can't open a file that is in use on the network PCLIVE Excel Discussion (Misc queries) 0 February 4th 09 07:30 PM
Excel can't open network drive! Meneos Excel Discussion (Misc queries) 3 September 5th 08 12:43 PM
on network, pc a & pc b share pc x only open [read only] ipcvb Setting up and Configuration of Excel 1 October 7th 05 12:15 AM
excel does not open file in network Bram Excel Worksheet Functions 0 August 21st 05 07:21 PM
excel template to open from network kurt Excel Programming 0 September 18th 03 12:42 PM


All times are GMT +1. The time now is 01:55 AM.

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

About Us

"It's about Microsoft Excel"