Find Pictures and Insert into Cell Comments

  • I need a Macro to find pictures located in file c:/ pictures/inventory. They are named with the inventory number and .jpg. (1000.jpg).
    In the inventory sheet Column A is the corresponding Item Number. (1000). It should get the inventory number,search the picture file , find the picture and [ATTACH]n1195537[/ATTACH] insert a comment box, add the picture into Column "C". Then format the picture size to 3" tall. If no matching picture is found, comment "Not Found".

  • This should get you close.

  • I stand and applaud your experties Ken.. I did have to modify the VBA code and remove the blank in the second line.
    p = " c:\pictures\inventory". Exactly what I needed. Thanks

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!