Skip to content

Latest commit

 

History

History
13 lines (12 loc) · 538 Bytes

File metadata and controls

13 lines (12 loc) · 538 Bytes

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