Overview

• VBA Documentation project

VBA Project Setup

• Use Rubber Duck when you need to work with external References AutoCAD, Word, Powerpoint references
  • Refactor Code
  • Intellisense support for classes and internal methods
  • Object browser using F2
  • Ability to group related to modules using folder Attributes
• Use XlWings when working with modules and code generation
  • Can take benifits of VS Code functionality
  • LLM Support using Copilot and Codium
  • Open Excel, run xlwings vba edit and start coding