Blog posts

Getting information about the code at the cursor ... for declarations in your VBA Project, and things declared outside of your VBA Project

Ever wanted to know how many procedure or properties there are in your Project? Or how many code / comment / blank lines? Or how many of those lines are declaration lines? The the Project Stats command is for you.

VBE_Extras will show a dialog containing a list of all declarations from any procedure/property, Module or VBA Project.

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.