VBA-Scripting | RadiusCore VBA Tools

Status: Incomplete

Native VBA implementation of Microsoft Scripting Runtime (scrun.dll). Aims to provide Mac support for this library.

Development Environment

Environment

Recommended development environment is 64-bit Office-365 Excel running on Windows 10. Highly recommended to have Rubberduck VBA installed to improve the VBE, this is required for Unit Testing.

Build

VBA-Git is a tool that provides git repository support for Excel/VBA projects. It should be used to build an .xlam file from repository source.

Usage

Manual

To manually add VBA-Scripting to a VBA project, import any of the target classes to the project using standard VBE import procedures.

VBA-Git

To easily include VBA-Scripting in any VBA project, use VBA-Git to build the target project, ensuring this repository is listed as a dependency in the project's configuration file. An example is included below, however additional information on how to do this can be found in the VBA-Git ReadMe,

"VBA-Scripting": {
    "git": "https://github.com/VBA-Tools-v2/VBA-Scripting",
    "tag": "v0.2.2",
    "key": "{readonly personal access token}"
}

Example

TODO