Save output file to have permissions for everyone

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
welcome 123Asked:
Who is Participating?
 
ragnarok89Connect With a Mentor Commented:
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
0
 
welcome 123Author Commented:
You are right. I did that. Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.