Been there - done that
I had to write some temporary code in (gasp) Excel VBA to extract data and reformat it so we could invoice the customer. The old manual way was taking 2 weeks man time every month - mine took 10 minutes (and did more). It was supposed to last 12 months while they designed and built something "better".
As far as I know, the code is still being used 5 years later. It just worked! I did fully document it which I supposed helped.