Auto Click
Auto Click records every mouse click you make together with its screen coordinates and timing, stores them as a table on the active sheet, then replays that exact sequence for as many loops as you configure.
Use it for repetitive work in software that has no "run in bulk" button and no macro support: stepping through page after page in an estimating package to export reports, ticking hundreds of approval rows in a document-control portal, repeating a click sequence in design software.
License required
This command needs a valid DVDAddin account (Standard or PRO). It is fully available during the Trial period.
Commands in this group
Auto Click sits on tab DVD Addin → group Graphics → Shape Menu. Before reaching for it, check whether a purpose-built command already covers the job — a real command is always faster and safer than simulated clicks.
| Command | What it does |
|---|---|
| Auto Click | Record and replay a click sequence by screen coordinates, with loop count and delay |
| Batch print | If the repetitive job is printing or exporting PDFs from Excel, use this instead |
| Merge to Word | If the repetitive job is issuing one document per data row |
| Capture and Annotate | Capture the target application to document exactly where the clicks must land |
| Find Cmd | Keep your frequently used commands one click away (Ctrl+Shift+Q) |
Recording and replaying
- Open a blank sheet — the click table is written to the active sheet, so never record on a sheet holding data.
- Go to tab DVD Addin → group Graphics → Shape Menu → Auto Click. The Auto Click — record and replay mouse clicks window opens.
- Press Recorder to start capturing. The Last click field shows the coordinates just captured, and each click is appended to the sheet as a row with the columns No. / Timestamp / X / Y / Wait (ms).
- Perform exactly one round of the sequence in the target application, then press Recorder again to stop.
- Fine-tune on the sheet if needed: edit X / Y to shift a click, edit Wait (ms) to give the target application time to respond.
- On the Loop: line, enter the number of repeats and the seconds between rounds.
- Press Run. The status line (initially Ready) shows progress; press Stop to interrupt at any moment.
Always trial one or two loops, check the result, and only then set the real repeat count.
Example
You have to export 60 inspection records from a QA/QC application, and each one takes the same four clicks: the next record arrow → Print → pick the PDF printer → Save.
Open Auto Click on Sheet1, press Recorder, perform the four clicks for the first record, press Recorder again. The sheet now holds:
| No. | Timestamp | X | Y | Wait (ms) |
|---|---|---|---|---|
| 1 | 09:12:03 | 1180 | 240 | 0 |
| 2 | 09:12:05 | 640 | 96 | 1800 |
| 3 | 09:12:08 | 720 | 415 | 2600 |
| 4 | 09:12:11 | 905 | 640 | 3100 |
Set Loop: 59 times, wait 3 seconds between rounds and press Run — the sequence repeats for the remaining 59 records while you step away for about six minutes.
Tips and caveats
- Replay uses absolute screen coordinates. Do not move or resize the target window, and do not change screen resolution or display scaling between recording and running, or the clicks land in the wrong place.
- Only mouse clicks are simulated, never keystrokes. Any step that requires typing cannot be automated here.
- The clicks are real clicks delivered to whatever window sits under the cursor — test with a small loop count before running against live data.
- While it runs the program drives your mouse; keep the Stop button reachable and allow enough seconds between rounds for the target application to respond.
- The click table overwrites the active sheet — switch to an empty sheet before recording.
- If a purpose-built command exists (batch printing, PDF export, Word merge), use it. Auto Click should be the last resort, for software outside Excel.
See also
- Shapes and Colour — the other commands in Shape Menu.
- Batch Print — automate printing and PDF export inside Excel.
- Merge to Word — issue documents in bulk from a data table.