Skip to content

RELEASE_NOTES.md

Latest commit

 

History

History
143 lines (94 loc) · 3.48 KB

RELEASE_NOTES.md

File metadata and controls

143 lines (94 loc) · 3.48 KB

v2.0.2

VbaCompiler v2.0.2 updates the OpenMcdf library to v3 and improves the reliability of compiled VBA source code.

Changes

  • Updated OpenMcdf library to v3.1.0 for improved CFB file format handling.
  • Ensures the compiled VBA source code matches the original content.

Installation

Install as a .NET tool:

dotnet tool install --global vbamc --version 2.0.2

Upgrade from previous version:

dotnet tool update --global vbamc

Add VbaCompiler library to your project:

dotnet add package NetOfficeFw.VbaCompiler --version 2.0.2

v2.0.1

VbaCompiler v2.0.1 is a hotfix release which ensures Microsoft Office macro files are generated correctly.

Fixes

  • Ensures the generated macro project files are valid.
  • Reverted OpenMcdf library update to maintain compatibility (kept at v2.4.1).

Installation

Install as a .NET tool:

dotnet tool install --global vbamc --version 2.0.1

Upgrade from previous version:

dotnet tool update --global vbamc

Add VbaCompiler library to your project:

dotnet add package NetOfficeFw.VbaCompiler --version 2.0.1

v2.0.0

VbaCompiler v2.0.0 is a major release that brings support for .NET 10, modernizes dependencies, and improves performance.

What's New

  • The VbaCompiler library and vbamc tool work on .NET 8 and 10 runtimes.
  • Works on Linux, macOS, and Windows.

Installation

Install as a .NET tool:

dotnet tool install --global vbamc --version 2.0.0

Upgrade from previous version:

dotnet tool update --global vbamc

Add VbaCompiler library to your project:

dotnet add package NetOfficeFw.VbaCompiler --version 2.0.0

Usage

Use vbamc tool to generate a PowerPoint macro-enabled presentation:

vbamc --module Module.vb --class MyClass.vb --name "VBA Project" --company "ACME" --file Presentation.ppam

Using VbaCompiler library

using DocumentFormat.OpenXml.Packaging;
using vbamc;

var compiler = new VbaCompiler();
compiler.ProjectId = Guid.NewGuid();
compiler.ProjectName = "My Macro Project";
compiler.CompanyName = "ACME";
compiler.AddModule("Module.vb");
compiler.AddClass("MyClass.vb");

// Generate the vbaProject.bin file
var vbaProjectPath = compiler.CompileVbaProject("obj", "vbaProject.bin");

// Generate Excel macro file
var macroFilePath = compiler.CompileExcelMacroFile(
    "bin", 
    "MyMacro.xlsm", 
    vbaProjectPath, 
    SpreadsheetDocumentType.MacroEnabledWorkbook
);

Dependency Updates

  • OpenMcdf 3.1.0: Updated to the latest version of OpenMcdf library for improved CFB (Compound File Binary) file format handling.
  • DocumentFormat.OpenXml 3.3.0: Latest version provides better Office Open XML document processing.
  • NetOfficeFw.VbaCompression 3.0.1: Updated compression library for VBA project files.
  • Microsoft.SourceLink.GitHub 8.0.0: Enhanced debugging experience with up-to-date source linking.

Infrastructure Enhancements

  • Modernized CI/CD: Updated release workflow with Trusted Publishing for more secure package distribution.
  • Artifact attestation: Enhanced security with artifact attestation in the release process.
  • Automated dependency updates: Configured Dependabot for GitHub Actions to keep CI/CD dependencies current.

Breaking Changes

This major release removes support for .NET 6 and .NET 7. The project now targets only .NET 8 and .NET 10.

Acknowledgments

Thank you to all contributors who helped make this release possible!