Roger,
a long time ago, back in my film days, I had an EOS1N, and used a Sigma 90mm Macro. It was a cracker.
For closer stuff you need a bellows unit, and this is more fiddly, very much so. But if you want close, then fiddly is part of the deal.
Try
http://www.iceinspace.com.au/forum/s...ad.php?t=30006 This is a set of Nikon bellows, and THE best I have used. If it helps, I have a couple of top quality enlarger lenses which you could try. These work exceptionally well.
I could be wrong, but I would seriously doubt the auto-focus will work. On some brighter lenses, and some cameras, the "focus assist" function may work.
Good luck, it is a fantastic area of photography.
Gary