Blog posts

The Module-picker is a quick, keyboard-centric way of navigating between Modules in a VBA Project, so it's of most benefit to people that prefer using the keyboard to navigate around a Project rather than the mouse. It replaces the build-in behaviour of the VBE that acts in a similar, though less user-friendly, manner.

Getting extended file / folder attributes using the GetFileAttributesEx Windows API Function

The ":Zone.Identifier:$DATA" alternate data stream (ADS) ... unblocking files that have the "Mark of the web"

How to read, write and delete the alternate data streams (ADS) for a file or folder using VBA code?

How to get a list of the alternate data streams (ADS) for a file or folder using VBA code?

Expanding and unexpanding environment strings using the Windows API.

Working with the clipboard using the Windows API ... put text into the clipboard, get text from the clipboard, empty the clipboard, check whether the clipboard contents have changed.

A feature that I felt was missing from VBE_Extras was the ability to open the Microsoft documentation web pages. This feature now exists.

The VBE has a habit of changing the letter case of words (that are code ... not literal values and/or comments) when you are typing in code. For example, I often find that the letter casing of the word "Value" gets changed to "value". VBE_Extras now includes a "Fix case" command that will correct the case for all matches of that word.

The AutoText functionality of VBE_Extras already provided numerous ways to speed up entering code ... now it has one more trick up its sleeve: numeric and String expansions for ++, --, +=, -=, *=, /=, \=, ^=, &=