Being a macro/addin programmer

Hi there

I am mech. eng. familiar with CAD 3d systems and learning programming. I am thinking about start to be a macro/addin programmer as a freelancer maybe. Is it a big need for this kind of programs and how much i can earn for this kind of work?