Advanced Excel Add-Ins
summary
Explains building pure VBA Excel add‑ins (no COM/XLL or managed code), shows using custom UI editor or Andy Pope’s RibbonX for ribbon XML, and chooses xlsb for smaller, binary files. Covers 32/64‑bit conditional compilation, local versus network read‑only deployment (browse → click No so updates publish centrally), storing settings outside the add‑in, example UDF (circle area) with full validation, ADO call to AdventureWorks (dimAccount ~100 rows), and notes weak VBA protection and tools like Add‑in Express, VSTO, VBS+Task Scheduler.
AI-written summary · about
chapters (17)
- 0:00Advanced Excel Add-Ins intro
- 1:46Excel Add-Ins overview
- 3:56Add-In benefits and pitfalls
- 8:10Local vs application methods
- 12:1132-bit vs 64-bit compilation
- 19:34Ribbon XML customization
- 23:36Add-In deployment strategies
- 24:38Network settings persistence
- 25:01Writing robust UDFs
- 31:01Ribbon XML and VBA demo
- 41:11Excel Add-Ins and SQL Server
- 44:26VBA Add-In security
- 49:22VBA trust and versioning
- 51:38VSTO alternatives
- 53:50Macro disabling and workflows
- 57:17Scheduling Excel tasks
- 1:03:20Q&A
related talks
58mProductivity Revolution in Excel
01h 00mMastering the CUBE Functions in Excel 2013
11mThink Inside the Box(es) Excel-Hosted Dashboards With Python Graphics
19mDAX in 20 Minutes - The Hard Parts
34mHomoiconic spreadsheets: What, How & Why
42mHow to Get the Most Out of Your BI Tools
47mFrom Power BI to Excel - The best of two worlds
49mVisualizing Data: the Good, the Bad, and the Ugly