How does one go about learning how to and understanding the science of writing code/scripts so that one can develop what he needs as simpe (or nearly as simple) as if it was macro recording?

Thanks in advance.