How can I create VBA code that runs on both 16-Bit and 32-Bit platforms?
The primary obstacle to creating an add-in that will run on both 16-bit and 32-bit platforms is the use of API calls. Two techniques are currently available for working around the problem of API calls. Conditional Compilation Conditional compilation is only available in Visual Basic 4.0 currently.