Solver

Location on ribbon: Tab DVD Addin → Group AI → Menu AI Menu

Command ID: btnAISolver

License required

This command needs an active DVDAddin account (Standard or PRO). During the Trial period it is fully available.

What it does

Takes an image or PDF containing questions, sends it to Gemini with an instruction to reply with the answer only, and writes the result into the cell you had selected. In practice it is OCR plus question answering in one step: photograph the question sheet, pick a target cell, and the answer lands straight in Excel. Typically used when revising for a professional or site-safety certification, or when a batch of multiple-choice answers has to be captured into a spreadsheet.

How to use

1. Select the target cell that will receive the answer (the command uses the active cell).
2. Go to tab DVD Addin → group AI → AI Menu → Solver.
3. The Pick image or PDF dialog opens, pre-filtered to *.png, *.jpg, *.jpeg, *.webp, *.pdf. Choose one file and click Open.
4. A "Sending to Gemini OCR…" message appears while the file is uploaded and the answer is awaited.
5. When the reply arrives, ** markers are stripped and the answer is written to the selected cell; a message confirms which address received it.

Example

You are building a site-safety revision sheet in Excel: column A holds the question numbers, column B is empty and waiting for answers. Screenshot a page of ten multiple-choice questions and save it as safety_quiz_p1.png. Select cell B2, run Solver, and pick that image. A few seconds later B2 contains Gemini's answer, for example 1-B; 2-A; 3-D; 4-C; 5-A; 6-B; 7-D; 8-C; 9-A; 10-B.

Notes

• A cell must be active; otherwise the add-in reports "Please select a cell to receive the result" and stops.
• Only one file can be picked per run; blurry photos or skewed scans produce wrong answers.
• The result is written by cell address on whichever sheet is active when the reply arrives — do not switch sheets while waiting, or the answer lands at the same address on the wrong sheet.
• It overwrites the target cell and cannot be undone with Ctrl+Z.
• Requires Internet and a Gemini API key in Preferences ▸ AI Assistant; if Gemini does not respond, a dialog reports the failure with details.

Related

• OCR — extract all the text from an image or PDF rather than just an answer.
• Screen clip OCR — grab a region of the screen and recognise the text in it.
• Read PDF — open and work with PDF documents directly.
• AI Chat — free-form questioning when you also want the reasoning.