Resize Images

Location on ribbon: Tab DVD Addin → Group File and Print → Menu File Tools

Command ID: btnResizeImages

What it does

Batch-shrinks every JPG/PNG in a folder so that the longest side matches the pixel target you enter, keeping the aspect ratio. Originals are never touched; the results land in a ResizeOutput sub-folder.

Site photos from a phone are typically 4000×3000 px and 4–6 MB each. Dropping them straight into a site diary or an inspection record inflates the workbook to hundreds of megabytes and makes it crawl. Resizing to 1200 px first cuts the file size by an order of magnitude and still prints sharply.

How to use

1. Go to tab DVD Addin → group File and Print → menu File Tools → click Resize Images.
2. The "Please select a folder" browser opens → point it at the photo folder → OK.
3. An Excel input box asks "Enter the maximum dimension for width or height (pixels)", pre-filled with 800 → change it to your target → OK.
4. The command creates a ResizeOutput sub-folder inside the photo folder and processes each .jpg, .jpeg and .png in turn.
5. A summary appears (how many resized, skipped, failed) and asks "Open the result folder?" — click Yes to open ResizeOutput in Windows Explorer.

Example

D:\Site\Photos_May holds 180 rebar-inspection photos at 4032×3024 px (~4.5 MB each).

Run the command and enter 1200 → D:\Site\Photos_May\ResizeOutput\ now holds 180 images at 1200×900 px, roughly 250 KB each. Use Insert Pictures afterwards to drop the whole batch into the site diary.

Notes

• Originals are left untouched; every result is written into the ResizeOutput sub-folder.
• Only .jpg, .jpeg and .png are handled; other formats (HEIC, TIFF, BMP) are ignored.
• Only images directly inside the chosen folder are scanned — sub-folders are not walked.
• Running it a second time skips images that already exist in ResizeOutput — delete or rename that folder first if you want to redo the batch at a different size.
• An image smaller than the target is scaled up to that long side, so do not enter an oversized number.
• Corrupt images are only counted as "failed"; the rest of the batch keeps running.

Related

• Insert Pictures — drop the resized batch into the sheet.
• Insert Picture By Name — match images to rows by file name.
• Export Images — the reverse direction: pull embedded images out of a workbook.
• Move / Resize Picture — align pictures already placed on the sheet.