The VBA Compiler Startup Kit is a optional purchase for the free VBA Compiler AddIn. The AddIn itself allows you to compile VBA (if compatible) code to a VB.NET COM visible DLL that can be used/executed directly from VBA.
What it contains
It contains a rich mix of code examples which exhibit some common issues as well as usable/compilable code examples that can well aid you in using the VBA Compiler. You can achieve many powerful things with the VBA Compiler that you will specifically learn by using this kit. My personal favorite example is For Loop multithreading which isn’t achievable in native VBA – allow you to squeeze awesome performance from your compiled code.
What code examples will you find?
Currently the VBA Compiler Startup Kit contains the following code examples:
|Hello World||Simple string concatenation function|
|Typical VBA practices that won’t compile to VB.NET||Some typical compilation issues you may run into and how to fix them|
|Edit Excel||Edit your running Excel Workbook directly from your VB.NET DLL. Set a Range or Cell value|
|Passing arrays as arguments||How to pass arrays to your VB.NET Subs and Functions|
|Sharing Classes and other objects||Sharing VBA Classes and other objects with your VB.NET DLLs|
|Returning multiple results from VB.NET||How to return multiple results from VB.NET by passing them by ref|
|MessageBoxes and InputBoxes||How to use MsgBoxes and InputBoxes?|
|Quick Sort||Comparing QuickSort algorithms on a VBA Array of Long variables (VBA vs. VB.NET)|
|Hacking VBA – Multithreading||How to hack your VBA code to enable VB.NET parallel multithreading of VBA loops|
Buy it and support the project!
By buying the VBA Compiler Startup Kit you are supporting the development of this Add-In.
Having issues with purchasing/downloading the kit? Write directly to me at analystcave(at)gmail.com!
How to Pay with a debit or credit card via PayPal