Too tired to drive out to a location for Macro Photography, or just don't have the time or want to deal with the traffic. Try your backyard! You will be amazed at some of the small creatures or unusual things you can find.
Best news is those old lens you have lying around make wonderful Macro lens with the simple addition of a cheap reversal ring. If your doing a reversal ring a good lens to use is something around 100mm, I find it offers good distance and great magnification. To get started using a reversal ring, you buy one made for your camera body, in my case Nikon, then you determine which lens your going to use and acquire the necessary adapter that will screw into the "filter" front end of your lens allowing it to be mounted in reverse.
The challenges with this set up is your basically working in manual mode for focus and aperture settings, and this is why it is important that the lens you choose for reversal have a manual aperture ring settings. You can pick up some reversal rings from ebay for as little as $15.00, or you can purchase one direct from your camera manufacture but normally it cost much more.
In addition to reversal rings, some folks add in an extension tube there by even closer focusing, but I recommend you master the stand reversed lens, then try other equipment.
If you have some coins to spend you can buy a standard macro lens and there are many out on the market. Both by third party manufactures and your camera manufacture. Just google Macro Lens, again I recommend starting out with a 100mm or greater. You can save some money searching for used macros, don't worry too much about auto focus as I find it too un reliable especially in low light.
I included some of my recent Macro shots taken right in my back yard, time to travel and process the shots were less that an hour. Most of the time was trying to focus and time the shot with the wind to get the sharpest photo possible.
I also included a video from You Tube that may inspire you to give it a try.