VBA: Unicode Strings and the Windows API

In this post, we talk about Unicode, about Strings, about how they sometimes become unexpectedly mangled when you pass them around the system and what we can do about it. We’ll see some Chinese ideograms, peek into memory and display some nonsense on screen in the process. VBA likes Unicode Internally, VBA handles strings in... » read more

VBA for 32 and 64 bit systems

I’ve put off writing about x64 MS Office because I was a bit lazy and hadn’t build the necessary environment to test it properly. In my day-to-day job -as far as Access is concerned-, I have so far targeted the 32 bit (x86) version of Office 2010 but the 64 bit version is bound to... » read more