Microsoft Visual Basic for Applications is a core tool and remains just as flexible as any other language but is especially useful in my daily work. Like Python, PHP, PERL, Go, PowerShell, LUA, C++, C, C# and more, there's a place for it, so this is here to share some hints.

While most VBA code can be used in any application context provided that the appropriate object references are present on the platform. MSAccess code can be used in the MSExcel context. MSWord code can be used in the MSPowerPoint context, etc. So the appropriate references are noted wherever the functionality is required.

By Default, all code is assumed to be part of the VBA7 dialect. For those of us who still know how to use Windows APIs, we use them. That's what they're there for…