I managed to get a VB script setup in an excel file that will update specific manual tag. So for example if there is a manual light switch and the user turns it on they will then open this excel and click on the ON button and it will update that result in PI and vice versa for OFF when then turn it off. (this is just a simple example).
everything works fine from my computer but each time I would bring the file to our engineer to show him it would fail. I thought it may be because he has windows 10 but now I realize that his user does not have access to add data to a tag. is there a way that I can set security rights to allow specific users the ability to write data to a single tag?