Windows API in VBA - Strings (Part 2) - Unicode vs. ANSI

In this 3rd video in the series on using the Windows 32 API in #VBA, we look at how to handle #Unicode strings in VBA, particularly with the #Win32API. We revisit the #MessageBox and #GetDefaultPrinter API functions, but this time their Unicode (W) implementations. We learn how automatic String #Marshalling helps us with ANSI data but how we have to circumvent it to pass Unicode strings by using the #StrPtr function in VBA.

Video Chapters
00:00 Intro
01:55 Unicode data - Fine in Access, a problem in VBA
06:48 Presentation - ANSI vs. Unicode / API vs. VBA
16:50 Presentation – String Marshalling
19:01 Presentation – Unicode in the Win32-API
23:13 Key points in the Win-API documentation
26:26 API declaration of strings for Unicode
28:10 The StrPtr function in VBA
31:43 Getting Unicode data from the Win32-API
37:10 Unicode in the VBA IDE
40:20 Outro

Links:
Windows API Reference: https://docs.microsoft.com/en-us/wind...
Windows Data Types: https://docs.microsoft.com/en-us/wind...
MessageBox function: https://docs.microsoft.com/en-us/wind...
GetDefaultPrinter function: https://docs.microsoft.com/en-us/wind...

Cheat Sheet of the most important data types: https://codekabinett.com/download/win...
Download of a lot of VBA API Declarations: https://www.microsoft.com/en-us/downl...