X-VBA

About X-VBA

X-VBA is a collection of utility tools and programs for working with the Microsoft Office Suite of programs (Excel, Word, PowerPoint, Outlook and Access) and with the Visual Basic for Applications (VBA) language. These tools were created by Anthony Mancini, and below are all of the programs in the X-VBA collection.


XPlus

XPlus is a Microsoft Excel function library that contains over 100 functions. It is written in pure VBA and is MIT Licensed (and thus is free to use for personal and commercial use). Additionally, XPlus requires no external dependencies.

These features of XPlus make it extremely portable, since you can incorporate XPlus into an Excel Workbook, send it to someone else, and they will be able to use XPlus as well without having to install it themself. This ensures that the users of XPlus won't need to worry about if their Excel Spreadsheets will run when sending them to others, as XPlus can be incorporated into the actual Workbook.

XTemplate

XTemplate is a program for Microsoft Word, PowerPoint, and Outlook for easily pulling data from Excel Spreadsheets and placing the data within templated areas of the Document, Presentation, or Outlook Email. This makes it very easy to update recurring Word Documents, PowerPoint Presentations, and Outlook Emails and Appointments with data from Excel Spreadsheets, since you simply place templates within your other Office files, and have XTemplate fetch the data for you.

XTemplate is written in pure VBA, has no external dependencies, and is MIT Licensed, making it free to use for personal and commercial use.

XLib

XLib is an open-source VBA function library that contains around 120 useful functions, making it easier to create programs using VBA. It works for Microsoft Word, Excel, PowerPoint, Access, Outlook, and Publisher.

XLib is written in pure VBA, has no external dependencies, and is MIT Licensed, making it free to use for personal and commercial use.

XDocGen

XDocGen is a tool used to generate documentation from VBA source code. It uses a basic tag language that can be placed throughout you VBA source code, and generates JSON from these tags and from the Functions and Subs within the code.

XDocGen is written in pure ES6 JavaScript, and has no external dependencies. It can be run within the browser, and does not require any installation to use, but you can also download XDocGen and run it using NodeJS. It is MIT Licensed, and is free to use for personal and commercial use.

XMinifier

XMinifier is a tool used to minify your VBA source code, removing any comments, excess syntax features, and excess whitespace. This can be useful when you want to ship your code, as it can result in a significant reduction in size (typically from around a 40% to 70% reduction in size), making it lighter to include your within Word, Excel, PowerPoint, Access, and Outlook files.

XMinifier is written in pure ES6 JavaScript, and has no external dependencies. It can be run within the browser, and does not require any installation to use, but you can also download XMinifier and run it using NodeJS. It is MIT Licensed, and is free to use for personal and commercial use.

XCombiner

XCombiner is a tool used to combine your VBA source code from multiple Modules into a single Module, removing excess Option Statements and Attribute name statements. This can be useful when you break up your VBA code into multiple Modules and then want to combine them together into a single Module when shipping your code.

XCombiner is written in pure ES6 JavaScript, and has no external dependencies. It can be run within the browser, and does not require any installation to use, but you can also download XCombiner and run it using NodeJS. It is MIT Licensed, and is free to use for personal and commercial use.




Contact

The X-VBA suite was created by Anthony Mancini. Please feel free to send me an email at anthony.m.mancini@protonmail.com with questions, suggestions, and feedback on these tools, and please feel free to visit my personal page which contains some other projects I have worked on.