far as I know it does not alter your camera aperture, what it does it to reduce the minimum focusing distance for the lens on the camera. This allows you to focus the lens much closer to a subject, on the right lenses the amount of magnification you are able to get is akin to proper macro magnifcation - though I am not certain what lenses it works best on.
At a closer focusing distance of the sorts used in macro work your depth of field at a given aperture will be much smaller - thus you need smaller apertures to get the depth back - think around f13. That does mean that one needs either a tripod for a long exposure (and a static subject) or a flash to add more light to a shot to allow for a good exposure and faster shutter speed (needed for handheld shooting)