Blog posts

Dynamically loading a DLL "on-the-fly"

Calling the members of a dynamic-link library (DLL, in a .dll file), from VBA code, without having to first (separately) register that DLL.

Oct 2, 202410 min read

Mandelbrot Set viewer - VBA vs C#

Using the Mandelbrot Set to demonstrate the relative speed of using C# code via COM Interop from VBA.

Sep 21, 20231 min read

Calling C# code from VBA (COM interop)

Update October 2024: This post uses Visual Studio and/or RegAsm to 'statically' register your C# library before it is loaded and used by your VBA code ... doing this requires your end-users to perform some level of installation (for the C# library) and also requires your end-users to have administrator permissions on their device. This is the "correct" way to go about COM interop. However, you may also be interested in my Dynamically loading a DLL "on-the-fly" post which (as

Feb 24, 202323 min read

Articles: Blog2