Thumbnails from Hyperlinks in CSV.

jim6149 · Aug 26th 2020

Hi all

I have a CSV file d/l from a wordpress form which has hyperlinks to photos. Is there a way to make thumbnails from the links? Or a more user-friendly way to present the hyperlinks so users don't have to copy/paste links individually into a browser to see them?

Thanks in advance.

davesexcel · Aug 26th 2020

I text split your jpeg files names in AB2 and then went to Insert=>picture and copy pasted the jpeg file into the file name and voila, your picture appeared.

If you were to use the macro recorder for this, you would end up with a code that looks like this.

Code

Sub InsertPic()


Range("W8").Select
ActiveSheet.Pictures.Insert( _
"http://awards.steel.org.au/wp-content/uploads/gravity_forms/10-f1b2857b6d5042f21faef57b20bb55a5/2020/08/20190828_033341302_iOS.jpg" _
).Select
Range("U34").Select
End Sub

jim6149 · Aug 28th 2020

Thanks Dave,

This will save a heap of time and frustration.

Thumbnails from Hyperlinks in CSV.

Participate now!

Share

Tags