Lovely eight minute video – perhaps shot on a Canon 5D mkII? (love that bokeh) – how to convert a stock kit lens into a macro. This is a stellar bit of cottage industry engineering:
via Gadget Lab
If you don’t feel that intrepid – there’s other, far simpler ways if you don’t mind manual focus and exposure… macro freelensing … or, same principle but with a bit more usability: buy a macro reversing ring for your SLR/lens combo on ebay (I’m waiting for mine to arrive…).