top of page
The VBA Help blog
Search
VBE_Extras catch-up #2: Listing all declarations
VBE_Extras will show a dialog containing a list of all declarations from any procedure/property, Module or VBA Project.
Apr 233 min read
Â
Â


VBE_Extras catch-up #1: The Module-picker (and the Project Picker)
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.
Apr 223 min read
Â
Â


Getting extended file / folder attributes
Getting extended file / folder attributes using the GetFileAttributesEx Windows API Function
Apr 133 min read
Â
Â


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


Reading, writing and deleting alternate data streams (ADS)
How to read, write and delete the alternate data streams (ADS) for a file or folder using VBA code?
Mar 33 min read
Â
Â


Getting the alternate data streams (ADS) for a file or folder
How to get a list of the alternate data streams (ADS) for a file or folder using VBA code?
Mar 23 min read
Â
Â


Expand / un-expand environment variable strings
Expanding and unexpanding environment strings using the Windows API.
Feb 272 min read
Â
Â


Put text into the clipboard / get text from the clipboard
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.
Feb 232 min read
Â
Â


Opening Microsoft documentation web pages using VBE_Extras
A feature that I felt was missing from VBE_Extras was the ability to open the Microsoft documentation web pages. This feature now exists.
Feb 183 min read
Â
Â


Fixing the letter case of code in the VBE
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.
Jan 261 min read
Â
Â


Articles: Blog2
bottom of page