| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting up Permissions or Security selection spreadsheet | Excel Discussion (Misc queries) | |||
| Setting read only permissions | Excel Discussion (Misc queries) | |||
| setting minumumScale of an axis programatically | Excel Programming | |||
| Setting sheet.xlt for a workbook programatically | Excel Programming | |||
| Setting Up Workbook Permissions | Excel Programming | |||
Hybrid Mode
