Most people today will end up in office jobs. Understanding how to automate tasks is a valuable skill.
You are wrongly assuming that anyone who codes is a developer. Lots of people code who aren't developers: physicists, mathematicians, engineers, technicians, statisticians, system administrators etc.
5-20 line programs can often be enough to save a lot of tedious work, wether it is a collection of unix shell commands, a complex spreadsheet formula, VB script or a visual programming tool like automator or labview.
You are wrongly assuming that anyone who codes is a developer. Lots of people code who aren't developers: physicists, mathematicians, engineers, technicians, statisticians, system administrators etc.
5-20 line programs can often be enough to save a lot of tedious work, wether it is a collection of unix shell commands, a complex spreadsheet formula, VB script or a visual programming tool like automator or labview.