Can I extract hyperlinks from images?

**skuba** · 05-15-2008, 08:03 PM

Hi,
I have copied and pasted a big table to excel. All the images have links and I need to extract that URL and post on it's own cell.
I have tried some hyperlink extracting code but I realized the images are not necessarily in a cell.

Is there a way to do this?

and by the way, is the a way to make the images show? I know they are there but they don't show.

I appreciate your help.

Thanks

**skuba** · 05-16-2008, 11:57 AM

Anybody?

Thanks

**skuba** · 05-16-2008, 07:04 PM

I have this mega project for monday. And a solution for my question would REALLY make a big difference.
I really appreciate.
Thanks

**Leith Ross** · 05-17-2008, 01:48 AM

Hello skuba,

I would help to see your workbook. The macro code below should get you going in the right direction. The macro copies the URL (hyperlink) from each Picture on the active sheet to to column "A" starting with row 1.

Please Login or Register  to view this content.

If you have any questions, let me know.

Sincerely,
Leith Ross

**skuba** · 05-19-2008, 12:03 PM

THank you.
But I did get an error on this line

Cells(NextRow, "A") = Shp.Hyperlink.Address

Please let me know if I should fix it.
Thanks

**Leith Ross** · 05-19-2008, 01:14 PM

Hello Skuba,

You don't say what the error is. I am guessing the active worksheet doesn't have any pictures on it or maybe the picture has no HyperLink. I will assume the former first. Change the worksheet name in red to the name of the worksheet that has the pictures on it. Delete the old macro and save the new macro after you have made the change.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**simarui** · 01-11-2012, 03:12 PM

This macro worked really well, except that for some reason it seems to have pasted some of the urls multiple times on consecutive rows. I'm trying to ensure that the url matches up with the document titles in row c.

help?

**ONGExcel** · 08-20-2012, 06:56 AM

Hi Leith,

Am super thick with Macros - have exactly the same question - just do not know where to go with the macro code?

Kind regards,
Lorna

**arlu1201** · 08-20-2012, 07:11 AM

Lorna,

As i told you earlier,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.