write to read only file

[vangxbg]

is there any way to set up permissions so that a user can write to a read-only file for an instant?

What I'm trying to do is create an inventory in excel in a network that's read-only for all users. The only time a user can enter information into that inventory is if they submit it through another excel file called enterToInventory.xls. Is there any way to do this through permission settings, or perhaps through vba on excel?

Is there such a thing? maybe give the user append only permission or something like that.

 

[carnageX]

You could do it in VB. Just set the script to set write permissions, do whatever needs to be done, and then set the permissions back to how they originally were at the end of the script.

Setting file and folder permissions-VBForums

 

[KSoD]

As I said in your other topic on the same exact subject. If the user is an Admin they can change the permissions and do what they want to the file.

So user permissions is going to be the same as file permissions.

You would need to do it via GPO.