Introduction

In the last week I’ve had a client upgrade to 64-bit Microsoft Office and it has caused some havoc with parts of my VBA. It’s the first time this has been an issue, and I thought I’d detail some of the effects. If you don’t care about reasons or explanations, skip to the summary to see how to avoid or fix the issues.

There are actually very few issues with moving code from 32-bit Office to 64-bit Office, but a couple of them are significant. More →