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 does not exceed 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. Progress is shown in Excel's status bar; press ESC to stop mid-run.
5. A summary appears (how many resized, skipped, failed — with the names of the failed files) and asks "Open the result folder?" — click Yes to open ResizeOutput in Windows Explorer.

Video tutorial

Narrated in Vietnamese, with Vietnamese subtitles. Chuyển Word, Visio sang PDF và xử lý ảnh · 5 min 52 s · 13 cases · Download the video · Practice workbook for the video

Commands in this video: Word → PDF · Export Images · Resize Images · Visio → PDF

Chapters (18)

1. Giới thiệu
2. Mở lệnh
3. 1 · Word → PDF cả lô
4. 2 · PDF đã có, file lỗi
5. 3 · Hai file trùng tên
6. 4 · Thiếu Word, Esc
7. 5 · Visio → PDF
8. 6 · Visio báo lỗi
9. Lệnh xử lý ảnh
10. 7 · Thu nhỏ ảnh
11. 8 · Ảnh dọc, ảnh đã nhỏ
12. 9 · HEIC, PNG, thư mục con
13. 10 · Chạy lại, nhập sai
14. 11 · Xuất ảnh
15. 12 · Ảnh nào ra
16. 13 · Xuất ảnh báo lỗi
17. Mẹo
18. Kết thúc

Illustrated walkthrough

Step 1. On the ribbon, open the DVD Addin tab → File and Print group → open File Tools → choose Resize Images.

Step 2. In the Please select a folder box choose the photo folder, for example D:\DuAn\NhaVanPhong\Anh_T10-2026, and click OK.

Step 3. Excel's input box asks Enter the maximum dimension for width or height (pixels): with 800 as the default — type the longest side you want, for example 1200, and click OK.

Step 4. The command creates a ResizeOutput sub-folder and processes the .jpg, .jpeg, .png images one by one (aspect ratio kept, EXIF rotation applied, small images never enlarged); the status bar shows Resize images… 45/180 — hold ESC to stop. When done, the add-in reports Resized 180 image(s). and asks Open the result folder? — click Yes to open ResizeOutput. The original photos are not changed.

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 already within the limit (long side at or below the target) is copied to ResizeOutput unchanged — never scaled up.
• The EXIF orientation is applied before resizing, so portrait phone photos stay upright.
• EXIF data (date taken, GPS, camera) is kept in the output; JPEGs are saved at quality 85.
• A corrupt image does not stop the batch: the rest keeps running and the final message lists the failed file names.

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.