extract urls from hyperlinked images

I have a list of about 1000 documents and folders each with an associated picture embedded with a hyperlink. I am trying to extract the hyperlinks from those pictures and keep them aligned with thier associated document/folder.

the following macro, originally posted by Leith Ross in 2005:

Please Login or Register  to view this content.

worked really well, except that it seems to duplicate all of the true urls. when i run the macro on my full list, i end up with 1000 extra urls, and matching them up to their associated doc/folder is nearly impossible.

Also of note, when it duplicates the url, it often adds one more space to the front, so removing duplicates doesn't really seem to help.

please help?