Is it the holy grail? How are close-up photos with the flash? I still have to rely on good light using my Canon G9 in macro mode.
If you read any guides about macro photography they tend to focus of photographing stuff that doesn't move, if anyone has seen (or has) any good guidance for macro photography using a compact camera and moving targets I'd be interested to see the links.
My tips would be:
1. Hold the camera still by resting on the side of the tank or something else solid, or I use a gorilla pod sometimes. It's better to compromise the composition slightly to get a steady shot, you can crop it down later but you can't fix camera shake in Photoshop.
2. Flash will always washout the shot, so turn it off and use good ambient light.
3. Use manual focus, choose the focal point and move the camera to that distance rather than using any zoom or relying on autofocus.
4. Use the self-timer to help eliminate camera shake.
5. Expect to miss something like half the shots you attempt.
This is based on what I've learned so far using my G9, obviously other cameras may not have the same features or may have different strengths/weaknesses.