Geek asks and answers

Conditional Compilation Based on Excel Version

I know that I can use conditional compilation in VBA to distinguish between 64-bit and 32-bit versions (using #If VBA7 Then ...).

Is there also a constant similar to Application.Versionso that I can distinguish Excel 2013/2010/2007 / ... etc. at compile time?

Also have a list of available existing compiler constants? So far I have found VBA7and Win64(for example, from this article) - but are there any others?

+5
source share
1 answer

From this link , you have the following constants:

VBA6
VBA7
Win64
Win32
Win16
Mac
+5
source

More articles:


All Articles