Comment by Name

Location on ribbon: Tab DVD Addin → Group Graphics → Menu Insert Pic Menu

Command ID: btnPictureCommentByName

What it does

This command attaches comment images to a whole range at once: for every cell it takes the cell value as a file name, looks for a matching image in the folder you choose, and sets that image as the comment background (hidden, four times enlarged, aspect ratio locked).

It is the fastest way to turn an existing coded list — element marks, inspection record numbers, material codes — into a photo lookup: hover over the code to see the picture, while the table itself stays print-ready.

How to use

1. Select the range holding the image names (usually the item-code column).
2. Go to tab DVD Addin → group Graphics → Insert Pic Menu → Comment by Name.
3. The Select images folder dialog opens — pick the folder and press OK.
4. The command walks each cell, clears its old comment, and attaches the matching image if one is found.
5. A toast reports how many cells received an image. Hover over a cell to view it.

Example

A level-5 blockwork inspection register keeps record numbers in column A. The folder D:\Records\Photos_L5 contains INS-501.jpg, INS-502.png, INS-503.jpeg and so on.

Select A2:A40, run the command and pick the folder. Cell A2 holding INS-501 gets INS-501.jpg; A3 holding INS-502 gets INS-502.png. Records with no photo yet are simply left alone. The register still prints on one page, but during document review a hover is enough to check the site photo.

Notes

• A range must be selected first; if the selection is not a range the command reports "Please select a data range" and stops.
• The cell value must be the file name without its extension (INS-501, not INS-501.jpg); the command tries .jpg, .jpeg, .png, .bmp and .gif itself.
• Existing comments are cleared on every non-empty cell, including cells where no matching image is found — any text comment there is lost.
• Only the chosen folder is searched, never its subfolders; matching is case-insensitive.
• Ctrl+Z will not undo this; to remove them in bulk you must select the range and delete the comments manually.
• With a large range and high-resolution photos the workbook grows a lot, because the images are embedded.

Related

• Pic Comment — attach a single image to the active cell.
• Insert by Name — same name matching, but the picture is placed on the sheet.
• File List — write the folder's file names into the sheet to build a matching code column.
• Resize Images — shrink photos before attaching them in bulk.