Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / May 2008

Tip: Looking for answers? Try searching our database.

Network file attributes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul D Byrne. - 28 May 2008 02:48 GMT
Hi,

I have created a program that generates excel templates which need to be
deleted by anyone logging on to the networked computer. I believe the network
is a Windows 2000 NT Server.

At the moment when the excel templates are created (say in C:\Temp or Shared
Documents) only the Admin and the User Id that created them can delete them -
Users only have read and read and execute security permissions. Hence if
anyone else logs on to that PC the files cannot be overwritten and an error
occurs. I need them to be Write accessible for all users.

Is there are way to change the network security property of a file using VBA?

thanks,

Paul B.
urkec - 28 May 2008 09:46 GMT
> Hi,
>
[quoted text clipped - 13 lines]
>
> Paul B.

There is sample (VBScript) code here:

http://msdn.microsoft.com/en-us/library/aa393592(VS.85).aspx

It would probably be simpler for you to use Cacls.exe:

http://support.microsoft.com/kb/135268

but maybe you should contact the administrator about the issue.

Signature

urkec

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.