Tips & Best Practices

Lessons learned from using DVDAddin effectively + advanced techniques for power users.

For new users

• Best Practices — 8 principles distilled for productive use of DVDAddin.
• Cheatsheet — keyboard shortcuts + UDF quick ref.
• Glossary — Vietnamese/English construction terminology.
• FAQ — 25 frequently asked questions.

For intermediate users

• Recipes — formula snippets combining DVDAddin UDFs + Excel built-ins.
• Performance Tuning — tuning large workbooks (10k+ rows, many UDFs).
• Backup & Restore — a backup strategy for license + workbook + settings.
• Customization — deep customisation through the registry, configuration files and the settings carried inside the workbook.

For power users

• Power User Tips — 20 advanced techniques (VBA + Excel + DVDAddin).
• Integration: Outlook — a deeper look at the two commands Send Email and Import Email.
• Integration: Word — a deeper look at Merge to Word and Word → PDF.

For admins / IT

• Security & Privacy — data flow, encryption, third-party APIs.
• Customization → Deployment to many machines — silent install through a logon script / SCCM / Intune (the installer is an Inno Setup .exe, there is no .msi package).
• Connect Server — a real-time teamwork session over LAN or MQTT (direct sync between the machines, not a cloud data store).

For developers

• Power User → Check which .xll build Excel is running — verify after installing over an existing version.
• Power User → Call the UDFs from VBA / Power Query — embed DVDAddin functions into your existing macros.
• Roadmap & Community — known limitations, contact channels, how to send a template and a file that reproduces the bug.
• GitHub releases — where the installer is published; the Check Update and Download Tool commands download DVDAddin.rar from here.

Patterns by use case

"I want to process 10,000+ rows quickly"

→ Performance Tuning + Best Practices → UDF.

"I need a safe backup for my license + projects"

→ Backup & Restore.

"I'm paranoid about privacy — where does the AI send my data?"

→ Security & Privacy.

"I have to print hundreds of records from a single template"

→ Power User → One template, hundreds of record sets (the Batch print window needs manual interaction; it cannot run unattended).

"I want to send a report to many people at once"

→ Integration: Outlook → Bulk email through Outlook.

"I want to deploy DVDAddin to a company with 50 machines"

→ Customization → Deployment to many machines.

"I want to override the default AI model"

→ Customization → Change the AI model manually.

"I found a bug and want to report it in the right place"

→ Roadmap & Community → Bug report template.

Suggest new content

Which tip would you like to see added? Send an email to [email protected] or post in the Zalo support group. All the official contact points are listed in the About window and under Roadmap & Community → Real contact channels.

Note: the GitHub repository is only used to publish the installer — the source code is not public and pull requests are not accepted.