Excellent. Thanks again!
--
Regards,

Kevin


"Zack Barresse" wrote:

Ivan Moala has a solution to checking if a file is open on a network or not,
an API method and a VBA method he
http://www.xcelfiles.com/IsFileOpen.html

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"Kevin H" wrote in message
...
Thank you. That does help. Is there a way that I can check to see if the
workbook has the shared setting=true and if so, set it to false
programatically ( exclusive editing permission) while we are working with
it?
I just want to code for any possible scenario.
--
Regards,

Kevin


"Tom Ogilvy" wrote:

If you open the workbook on a shared drive, the first person to open it
should have exclusive editing permission as long as you have not shared
the
workbook under the tools menu.

--
Regards,
Tom Ogilvy


"Kevin H" wrote:

Hello,

I am working on a project in which we need to set the permissions of
the
target Excel file so that the user has exclusive editing permission
(locks
out others to read-only permission). Since the target file could be
any
number of files, we want to set this permission when the application
begins
to open the target Excel file. Is this permission set at the Excel
level or
the OS level? How would I go about setting this? The version of Excel
we
are using is 2003, and win xp is the OS. Any help is greatly
appreciated!
--
Regards,

Kevin