Skip to content

VBA Wrapper Generator

The VBA Wrapper Generator (Protect tab → Advanced group) lets you preview and copy the typed VBA “facade” functions that call your compiled DLL. Instead of invoking protected logic through generic string-based commands, wrappers give you clean, IntelliSense-friendly calls.

VBA Wrapper Generator dialog showing generated code

💎 Type-Safe Automation

Section titled “💎 Type-Safe Automation”

By default, the VBA Bridge exposes a generic function called VBAPL_Execute. While powerful, it lacks IntelliSense support and type safety. Wrappers solve 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”

Generic call:

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

With a 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 Manual Integration Workflow

Section titled “🔄 The Manual 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”