Insert by Name

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

Command ID: btnInsertPictureByName

What it does

This command inserts pictures based on the file name written in a cell: you have a column of image names, and the command finds the matching file in the folder you point at and drops it into the corresponding target cell.

Unlike Pictures (which inserts in file-selection order), this one matches by name, so rows can never drift out of sync — ideal when your photo table already keys on a work-item code, record number or element mark.

How to use

1. On the sheet, prepare a column of image names and an empty range to receive the pictures (usually the neighbouring column).
2. Go to tab DVD Addin → group Graphics → Insert Pic Menu → Insert by Name.
3. The Pick images folder dialog opens (it starts in the workbook's folder) — choose the folder and press OK.
4. A picker asks for the "Cells with image basenames" — drag over the name column and press OK.
5. A second picker asks for the "Cells to insert images into" — drag over the target range and press OK.
6. An input box asks for "Spacing 2-5" (default 2) — the padding between picture and cell border. Press OK.
7. Pictures land in the target cells, and a toast reports how many were inserted and how many names had no matching file.

Example

A precast element photo register has element marks in column B and an empty column C for the photos. The folder D:\Photos\Precast holds PC-001.jpg, PC-002.png, PC-003.jpg and so on.

Column B (image name)	Column C — Before	Column C — After
PC-001	(empty)	photo PC-001.jpg
PC-002	(empty)	photo PC-002.png
PC-003.jpg	(empty)	photo PC-003.jpg
PC-004	(empty)	(empty — no such file)

The toast reads: Inserted 3 images, 1 not found.

Notes

• A name cell may include or omit the extension: PC-001 matches any extension, while PC-001.jpg matches only that exact file.
• The name range and the target range are paired by cell position, not by row — both ranges must contain the same number of cells in the same order, otherwise pictures land in the wrong places.
• Only files sitting directly in the chosen folder are searched; subfolders are ignored.
• Matching is case-insensitive; empty name cells are skipped and are not counted as "not found".
• If a target is a merged cell the picture is fitted to the whole merged area; how it fills follows the PictureFit setting under Preferences ▸ Graphics.
• Ctrl+Z will not undo this — delete the inserted pictures manually if you need to start over.

Related

• Pictures — insert in file-selection order when photo names do not match the table.
• Comment by Name — same name matching, but the image goes into a cell comment.
• File List — dump the folder's file names into the sheet to build the name column.
• Move/Resize — refit a picture into its cell after insertion.