setting permissions programatically
 

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

setting permissions programatically
 

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

setting permissions programatically
 

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

setting permissions programatically
 

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

setting permissions programatically
 

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

setting permissions programatically
 

Zack,
Have you ever tested that code on a shared workbook? With multiple people
using it? Just curious.

--
Regards,
Tom Ogilvy


"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

setting permissions programatically
 

Hi Tom,

I briefly tested parts of it, and it seemed to work as advertised. Although
I haven't tested extensively.

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


"Tom Ogilvy" wrote in message
...
Zack,
Have you ever tested that code on a shared workbook? With multiple people
using it? Just curious.

--
Regards,
Tom Ogilvy


"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