Skip to content

VBA Wrapper Generator

The VBA Wrapper Generator is a productivity tool that bridges the gap between generic API execution and elegant coding. Instead of calling your protected logic through complex string-based commands, this tool generates a native “facade” for your Office VBA project.

VBA Wrapper Generator dialog showing generated code

💎 Type-Safe Automation

Section titled “💎 Type-Safe Automation”

By default, the VBA Bridge uses a generic function called VBAPL_Execute. While powerful, it lacks IntelliSense support and type safety. The Wrapper Generator solves this:

  • IntelliSense Support: Generated wrappers use the exact same function names and parameter types as your source code, enabling full auto-complete in the Office VBA Editor.
  • Automatic Selection: The Script Tree allows you to toggle checkboxes for only the functions you want to expose to your Office UI.
  • Real-time Preview: See the generated code update instantly as you filter and select your routines.

🔄 Before & After

Section titled “🔄 Before & After”

Traditional (Manual) Call:

Result = VBAPL_Execute("Financials|CalculateTax", 5000, 0.2)

With Generated Wrapper:

' Clean, typed, and fully supported by IntelliSense
Result = CalculateTax(5000, 0.2)

⚡ Productivity Features

Section titled “⚡ Productivity Features”

Smart Filtering

Quickly find specific routines in large projects by typing in the filter field.

One-Click Copy

Review the code in the built-in preview and copy it to your clipboard with a single click.

🔄 The Integration Workflow

Section titled “🔄 The Integration Workflow”
  1. Compile: Ensure your latest changes are built into bytecode.
  2. Select: Open the Wrapper Generator and check the functions you wish to call from Office.
  3. Sync: Copy the generated code and paste it into a standard module in your Office file.
  4. Develop: Start calling your protected functions as if they were native VBA routines.

See Also

Section titled “See Also”