How to auto insert photo in excel with matching cell and pic fil

wilmoe - Nov 2, 2016 at 03:03 AM
I have a list of photos names that I would like to auto insert the photos into the cell according to the name.
For example: in cell B1 is pic1234, in cell W1, insert the picture named pic1234.jpg in f:/photo/
and repeat with B2,B3, so on.