Throwback Thursday: April 24, 2025
With over a million words scattered across more than 1,500 articles on this blog, you've probably missed a few things here.
That’s why each week in "Throwback Thursday," we’ll revisit some standout posts. Expect a blend of my personal favorites, insightful articles from other great minds, and a touch of coding humor to keep things light.
Highlights from NoLongerSet.com
Joining Paths in VBA
How many times have you gotten a runtime error because you had duplicate or missing backslashes in your file paths? Never again!
GetTempPath: Using the Windows API for Maximum Performance
If you are looking to maximize performance in VBA, using the Windows API will almost always be your best bet.
EnsurePathExists: A Unicode-Safe Way to Create Missing Subfolders in VBA
The EnsurePathExists function--based on the API function SHCreateDirectoryExW--is the ultimate tool for verifying and creating folder structures.
The Subtle Dangers of Dir()
If Len(Dir(FullPath)) > 0 Then ’the file exists. This potential bug patiently waits to pounce and ruin another poor programmer’s day.
Wisdom from Around the Web
Determine If A Filename Is Valid
In VBA, t is relative simple to validate if a filename meets the Windows naming requirements and if not, determine the elements causing failure.
How To Sanitize A Filename
A VBA function that allows us to sanitize proposed filenames to ensure they conform to Microsoft Windows file naming conventions and doesn’t include illegal chr
Developer Humor
painInAss
by u/Plastic-Bonus8999 in ProgrammerHumor
Cover image generated by Ideogram