Advanced VBA Programming |
|---|
| Course Outline |
Outline
|
| Reading Material |
|
| Introduction |
Intro-VBA005.pptx
|
| DAY | Topics | Sharing |
|---|
| 1 |
- Naming Conventions
- Best Practices for Application Structure and Organization
- General Application Development Best Practices
- The Four Stages of an Application
- Function Library Add-ins
- General Add-ins
- Application-Specific Add-ins
- Structure of a Dictator Application
- Practical Example
- Command Bar Design
- Table-Driven Command Bars
- Putting It All Together
- Loading Custom Icons from Files
- Hooking Command Bar Control Events
- The RibbonX Paradigm
- Ribbon Design and Coding Best Practices
- Table-Driven Ribbon UI Customization
- Advanced Problem Solving
|
|
| 2 |
- Command Bar and Ribbon User Interfaces in a Single Application
- Other Excel Development Issues
- Windows Security and Folder Structure
- Principles
- Control Fundamentals
- Visual Effects
- UserForm Positioning and Sizing
- Wizards
- Dynamic UserForms
- Modeless UserForms
- Control Specifics
- What Is an Interface?
- Code Reuse
- Defining a Custom Interface
- Implementing a Custom Interface
- Using a Custom Interface
- Polymorphic Classes
- Improving Robustness
- Simplifying Development
- A Plug-in Architecture
- Measuring Performance
- The PerfMon Utility
- Creative Thinking
- Macro-Optimization
- Micro-Optimization
- An Introduction to Databases
- An Introduction to SQL
- Data Access with ADO
|
|
| 3 |
- A Note on the Northwind Sample Database
- Designing the Data Access Tier
- Working with Microsoft Access Databases
- Working with Microsoft SQL Server Databases
- Upsizing from Access to SQL Server
- Excel's Data Structures
- Data Processing Features
- Advanced Functions
- Fundamental Techniques
- VBA Techniques
- Fundamentals
- The Primary Office Application Object Models
- Practical Example
- Why Use VB6 ActiveX DLLs in Excel VBA Projects
- In-Process Versus Out-of-Process
- Automating Excel from a VB6 EXE
- COM Add-ins
- The Add-in Designer
- Installation Considerations
- The AddinInstance Events
- Command Bar Handling
- Automation Add-ins
|
|
| Recommanded Books |
|---|
 | Title | Excel Revolution: Python with VBA in Excel: A comprehensive Guide For The Year 2024 |
|---|
| ISBN | 979-8-873-77946-8 |
|---|
| Author | Strauss, Johann; Van Der Post, Hayden |
|---|
| Year | 2024 |
|---|
| Publisher | Reactive Publishing |
|---|
 | Title | Vlookup Viking: The Ultimate Guide for Excel Warriors |
|---|
| ISBN | B0CRPZ6RTD |
|---|
| Author | Sampson, Josh; Van Der Post, Hayden; Strauss, Johann; Bissette, Vincent |
|---|
| Year | 2024 |
|---|
| Publisher | Reactive Publishing |
|---|
 | Title | The Art of VBA Mastery: A Cureated Expert Guide For VBA In Finance |
|---|
| ISBN | B0CRT9X9G9 |
|---|
| Author | Strauss, Johann; Bisette, Vincent; Van Der Post, Hayden |
|---|
| Year | 2024 |
|---|
| Publisher | Reactive Publishing |
|---|
 | Title | Master the Art of Automation: A Comprehensive VBA Guide for Finance & Accounting |
|---|
| ISBN | B0CRT56LHZ |
|---|
| Author | Sampson, Josh; Strauss, Johann; Van Der Post, Hayden |
|---|
| Year | 2024 |
|---|
| Publisher | Reactive Publishing |
|---|
 | Title | Excel and VBA Boosting Performance with Best Practices |
|---|
| ISBN | 979-8-223-17133-1 |
|---|
| Author | Americo Moreira |
|---|
| Year | 2023 |
|---|
| Publisher | Americo Moreira |
|---|
 | Title | The Ultimate Guide To Microsoft Excel Vba For Beginners And Seniors |
|---|
| ISBN | 979-8-215-36434-5 |
|---|
| Author | Mike Cage |
|---|
| Year | 2023 |
|---|
| Publisher | Bluerose Publising |
|---|
 | Title | VBA Automation for Excel 2019 Cookbook-Solutions to automate routine tasks and increase productivity with Excel |
|---|
| ISBN | 978-1-789-61003-1 |
|---|
| Author | Van Niekerk, Mike |
|---|
| Year | 2020 |
|---|
| Publisher | Published by Packt Publishing Ltd. |
|---|
 | Title | Microsoft Excel 2019 VBA and Macros |
|---|
| ISBN | 978-1-509-30611-4 |
|---|
| Author | Bill Jelen, Tracy Syrstad |
|---|
| Year | 2019 |
|---|
| Publisher | Microsoft Press |
|---|
 | Title | Mastering VBA 2019-For Microsoft Office 365, 2019 Edition |
|---|
| ISBN | 978-1-119-57933-5 |
|---|
| Author | Richard Mansfield |
|---|
| Year | 2019 |
|---|
| Publisher | Sybex Inc |
|---|
 | Title | Excel 2019 Power Programming with VBA |
|---|
| ISBN | 978-1-119-51492-3 |
|---|
| Author | Michael Alexander, Richard Kusleika |
|---|
| Year | 2019 |
|---|
| Publisher | Wiley |
|---|
 | Title | Excel VBA Programming for Dummies |
|---|
| ISBN | 978-1-119-51817-4 |
|---|
| Author | John Walkenbach |
|---|
| Year | 2018 |
|---|
| Publisher | Wiley |
|---|
 | Title | Programming Excel with VBA-A Practical Real-World Guide |
|---|
| ISBN | 978-1-484-22204-1 |
|---|
| Author | Flavio Morgado |
|---|
| Year | 2016 |
|---|
| Publisher | Apress |
|---|
 | Title | Excel VBA 24-Hour Trainer |
|---|
| ISBN | 978-1-118-99137-4 |
|---|
| Author | Tom Urtis |
|---|
| Year | 2015 |
|---|
| Publisher | Wrox |
|---|