Hmmm... That's an interesting approach.
============================================================== ASB - http://www.ultratech-llc.com/KB/?File=~MoreInfo.TXT ============================================================== -----Original Message----- From: Rangan, Govindaraj [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 7:12 AM To: NT 2000 Discussions Subject: RE: NTFS Permission management from Excel Andrew, Thanks for your mail. I'm looking at having the employee database in Excel sheet. Whenever a new employee joins or leaves, the concerned person has to update this Excel sheet and click a button, say "Update". The Excel macro should create/delete the directory at the right place and set the right permissions. Thanks, Govind -----Original Message----- From: Andrew Baker [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 1:39 AM To: NT 2000 Discussions Subject: RE: NTFS Permission management from Excel What does Excel have to do with this? This can be handled with scripting and CACLS. Then you won't need Excel at all. Setting permissions via the GUI is treacherous. See the following: http://www.ultratech-llc.com/KB/?File=Perms.TXT ============================================================== ASB - http://www.ultratech-llc.com/KB/?File=~MoreInfo.TXT ============================================================== -----Original Message----- From: Rangan, Govindaraj [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 8:06 AM To: NT 2000 Discussions Subject: NTFS Permission management from Excel Hi All, Greetings. My requirement is like this. I've to give the permission management of a directory structure to a semi-technical guy. The directory structure has to mimic the hierarchy. Boss - | |- Supervisor | |- Member A |- Member B And the permissions on these folders have to be managed in such a way that only the supervisor and his boss can see a member's folder. Member A should not be able to see Member B's folder nor his supervisor or his boss'. It so happens that the administrator always get into accidents when setting the permissions. I'm exploring the possibility of giving an Excel sheet and asking him to update the Excel sheet when a member joins, leaves or moves to report to someone else. I was just wondering whether VBA can do it. Before researching into it, I thought I would get some help from this mailing list. System: NT 4.0 SP6, Office 2000 Please help. Any alternative solution is also highly appreciated. Thanks, Govind. ------ You are subscribed as [email protected] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED]
