Save output file to have permissions for everyone

welcome 123
welcome 123 used Ask the Experts™
on
Hello,

I have a VB script code running in excel which saves a demilited file but I want to save it so everone will have full control on the file kindly help. I have the below code that saves it.

.SaveAs Filename:=sFileName, FileFormat:=xlText, CreateBackup:=False
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I do not believe this is possible, since Permissions are controlled by Active Directory. Typically only network administrators have access to AD.

That being said, what you could do is create (or have your admin create) a folder whith the explicit permission that Everyone has Full Control over the FILES in that folder. This way, when you, or anyone modifies the file (or any file in that folder) it will simply inherit the desired permissions set at the folder level.

Al

Author

Commented:
You are right. I did that. Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial