Hi Ken,

The conventional advice would be to develop the application in the lowest
version which, it is anticipated, it will be used.

This does not preclude the possible use of conditional compilation to
provide additional functionality to users of later versions.


---
Regards,
Norman



"Ken Soenen" wrote in message
...
The program that I am writing using Excel 2003 is spread over many modules
and is not totally compatible with Excel 2000. I get compiler errors in
many modules. My question is: how is this normally handled? I can use the
compiler constants #Const and its associated #IF statement to
conditionally compile certain pieces of code, but the Constant has to be
defined in EVERY module that you're going to use it in and then has to be
manually changed when you get the code over to the destination
machine(Excel Version). It all seems pretty cumbersome to me. Am I missing
something here?? Other than a few brain cells!!!



thanks,

ken