Search code examples
excelvbacompilationexcel-2010excel-2013

Conditional compilation based on Excel version

I know that I can use conditional compilation in VBA to differentiate between the 64bit and the 32bit version (using #If VBA7 Then ...).

Is there also a build in constant similar to Application.Version so that I can differentiate between Excel 2013/2010/2007/... etc. at compile time?

Also, is there a list of available existing compiler constants? So far I found VBA7 and Win64 (e.g. from this article) - but are there any other ones?

Solution

  • From this link, you have the following constants: 

    VBA6
VBA7
Win64
Win32
Win16
Mac