Insert picture based on cell value

[gledister]

Imagine we have this situation:

Excel Workbook
	A
1	25700
2	25709
3	25710
Sheet1

And we have in C:\pics these pictures
25700.jpg
25709.jpg
25710.jpg

at the end we must have at column B near each of them the picture related.

I am using the Excel image assistant add-in(free version) works fine but just one-by-one...anyone knows any alternative solution to this problem?

Any VBA code?

 

[Damon Ostrander]

Hi gledister,

I suggest using either ShowPic or ShowPicD, depending on whether you want the picture deleted if the picture file string is changed. See this posting: http://www.mrexcel.com/forum/showthread.php?t=100737.

Damon

 

[gledister]

Thank you!