Hi Josh,
The Vba version changed from VBA 5 to VBA 6 in Excel 2000.
New compiler constants were also created, so...

#If VBA5 Then
abc xyz
#ElseIf VBA6 Then
abc xyz, lmnop
#End If

Unfortunately, there seems to be no way to differentiate
between xl2000 and later versions using compiler constants.

Regards,
Jim Cone
San Francisco, USA


"Josh Sale" <jsale@tril dot cod
wrote in message

Is it possible to perform conditional compilation based on Excel version?
For example I have code that needs to continue to support XL97 but I'd like
to take advantage of new arguments to an Excel method introduced in XL2000
and later.

#If XL97 Then
abc xyz
#Else
abc xyz, lmnop
#End If
TIA
josh