I'd extend your comment to "Everyone should learn how to program". When you look at the number of repetitive tasks that take place in a typical office environment, it's amazing at how much time could be saved with a little programming.
Macros were designed to accomplish this, but they're still way to complicated to be used by most people. It would be great if there were some sort of easy to use third party system that could integrate with a number of products (Word, Excel, Websites) and provide an easy environment to build macros.
Edit: I'm basically thinking of OS X's Automator