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.

"Paul D Byrne." wrote:

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.



There is sample (VBScript) code he

http://msdn.microsoft.com/en-us/libr...92(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.

--
urkec