Good Lighting and a tripod
Don't use a flash, just make sure you have a lot of constant lighting. At the macro level, you'll have to bring the light in close. Several lamps with 60 watt bulbs should help you illuminate your subject well enough from all angles to avoid shadows. Use a tripod, set your camera to a 2 second delay if available, to avoid shake when you press the button and set the camera to the lowest iso setting available (if you have sufficient light), 50 on my sd300. As consumer models have smaller sensors, which causes them to experience noisy (grainy) images, this will help produce a better picture.
Below is an example of a picture of part of a stick of RAM. I took this with my Canon SD300 in macro mode at a distance of one or two inches. The photographed region is approximately 1cm square. I used a lampstand with three adjustable canister lamps, which happened to be handy, to illuminate the the RAM. At this range, the flash wouldn't have even worked. There are some shadows, since the lamp only illuminated from two sides. I adjusted the color balance slightly in iPhoto to reduce a yellowish tinge, probably due to using incandescent light. While it's perhaps not the most inspiring composition, and I'm sure there are some technical flaws in it, for an amateur with no special equipment other than a tripod (for this pic, a necessity) and a high-quality point and shoot, I think it turned out well.