Throwback Thursday: February 27, 2025

With over a million words scattered across more than 1,300 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

32-bit vs. 64-bit VBA: Deep Dive

A deep dive into the past, present, and future of the transition from 32-bit VBA to 64-bit VBA.

No Longer SetMike Wolfe

How to Check if VBA is Running in 64-bit Mode

A simple function (or class property) that returns whether the VBA code is running under 32-bit mode or 64-bit mode.

No Longer SetMike Wolfe

Office 2019 Runs in 64-bit Mode By Default. Here’s What That Means for VBA Developers

Through Office 2016, default installs used the 32-bit version of the software. Now that 64-bit is the default, it’s time to bite the bullet and convert your VBA code.

No Longer SetMike Wolfe

Should you install 32-bit or 64-bit Access in 2023?

Which version of Access (and/or Office) should you install: 32-bit or 64-bit? We go way deep into the differences and similarities between the two options.

No Longer SetMike Wolfe

Dropping `#If VBA7 Then` From API Declares

Plus, step-by-step instructions for restoring the `#If VBA7 Then` code construct if you still need to support Office 2007 or earlier.

No Longer SetMike Wolfe

Wisdom from Around the Web

Windows API declarations in VBA for 64-bit

How to convert your API Declarations to 64-bit. - Common myths debunked, key factors explained!

CodekabinettPhilipp Stiefel

32 to 64-bit Conversion

This article provides links to various web pages & utilities to assist with converting VBA code for use in 64-bit applications.

Isladogs on AccessColin Riddington

Access32to64

Access tools to help you convert 32-bit applications to 64-bit

thememydatabaseThemeMyDatabase

Developer Humor

Cover image generated by Ideogram