11 packages tagged with “vba”
Compiler vbamc compiles Visual Basic source code and Ribbon customizations to a macro enabled add-in file for Microsoft Office applications.
Library with compiler for Visual Basic for Applications projects. Source code files and Ribbon customizations are compiled to Microsoft Office macro files.
Excel automation for AI assistants - manage Sheets, Power Query, DAX, VBA, Tables, Ranges, Formatting, Validation and more. Requires Excel to be installed. Only runs on Windows.
A library for retrieving VBA callstack information at runtime from Office applications
Library to to simplify SQL database interactions. You will have tools like dlookup(), dmin(), dmax(), etc. This library is made for those who use Access VBA and use this functions. ExcecuteReader<T>() and ExecuteNonReader() are available in order to fill a strong typed class list from a sql query. It can consume an API.
C# library to support importing and exporting VBA code from an Excel workbook Check out the documentation, changelog, and example project here: https://gitlab.com/hectorjsmith/csharp-excel-vba-sync
vbSparkle is a source-to-source multi-platform Visual Basic deobfuscator based on partial-evaluation and is mainly dedicated to the analysis of malicious code written in VBScript and VBA (Office Macro). It is written in native C# and provides a .Net Standard library, and works on Windows, Linux, MacOS, etc.. The parsing of Visual Basic Script and VBA is processed through the use of ANTLR grammar & lexer parsers.
Command-line interface tool for automating Microsoft Excel operations using COM interop by Sbroenne. 165 operations across Power Query M code, Power Pivot DAX measures, VBA macros, PivotTables, Excel Tables, ranges, formatting, data validation, and connections. Perfect for RPA, CI/CD pipelines, scripting (PowerShell/Bash), and batch processing. Windows x64 and ARM64 support.
Library to to simplify SQL database interactions. You will have tools like dlookup(), dmin(), dmax(), etc. This library is made for those who use Access VBA and use this functions. ExcecuteReader and ExecuteNonReader() are available in order to fill a strong typed class list from a sql query. It can consume an API.
Open-source Excel add-in in C#/.NET4.0 that makes matrix, vector and most importantly, table-valued functions of Finaquant Calcs available for Excel users and programmers. Based on ExcelDNA and NetOffice
Excelize is a C# port of Go Excelize library that allow you to write to and read from XLAM / XLSM / XLSX / XLTM / XLTX files.