compile time directive - Excel version?

[Greg_R]

I would like to expand some of my macro functions so they work under multiple versions of Excel. With most languages I would use compile time directives. Visual Basic has these options but there are very few constants defined. If I do not use compile time directives then the code will not compile (certain functions can not be resolved). I only care about 2007 and 2010 versions (I use #vba defines for the older versions).

Is there a way of determining Excel's version number for use in compile time directives?

[romperstomper]

Please Login or Register  to view this content.

for 2010.
You can also simply put 2010 specific code into a separate module and use a check on Application.Version - you won't be able to compile the project, but it will work at runtime.

[Marcol]

Not sure if it helps with your problem but

Please Login or Register  to view this content.

Will return the version of excel you are currently using

[Greg_R]

Thanks romper, that fixed it...

[romperstomper]

Glad to help.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save