JohnApr 113 minWorking with files and folders in VBAWorking with files and folders from VBA code can be a hassle - here's my standard procedures to make working with files and folders simpler
JohnSep 21, 20231 minMandelbrot Set viewer - VBA vs C#Using the Mandelbrot Set to demonstrate the relative speed of using C# code via COM Interop from VBA.
JohnSep 15, 20231 minUnblock a file containing VBA codeSince mid 2022, files containing VBA code received over the internet or via email can be 'blocked' - preventing the VBA code from running.
JohnAug 10, 20232 minHow do YOU clear the Immediate window in the VBE?Want a better way to clear or scroll to the end of the Immediate window ... manually or automatically when you run code ... read this!
JohnMar 22, 20231 minCustom colours in the VBEGet fed up with the boring default colours available in the VBE's 'Options' dialog? Don't like cyan text on a magenta background ... make...
JohnFeb 24, 202319 minCalling C# code from VBA (COM interop)There's a number of sites on the web that discuss COM interop, but none too recent (that I can find) and most refer to calling VB.NET...