Do you use conditional compilation arguments?

[jeffreybrown]

Just curios, I heard about conditional compilation arguments the other day and not quite sure when or how I would use it. Does anybody use this technique and in its basic form how would you use it?

 

[MrKowz]

Another handy area is to create code that would be used on both Excel 2003 and Excel 2007+. Since some code from one won't compile or run properly in the other, you can create effectively two separate sets of code in the same procedure.

 

[RoryA]

Except you would have to change the compilation constant on each machine yourself.

 

[MrKowz]

Except you would have to change the compilation constant on each machine yourself.

Did Excel 2007 get VBA7? I thought I read somewhere that it was either Excel 2007 or Excel 2010 that upgraded to VBA7 (I haven't had a chance to dabble in either of those versions much at all), so you could do the compiler test:

#If VBA7 Then
    Public Const ExcelVersion As String = "Higher than 2003"
#Else
    Public Const ExcelVersion As String = "At least 2003"
#End If
 
Public Sub What_Version()
MsgBox ExcelVersion
End Sub

 

[RoryA]

2010 did, so it would work for that versus earlier versions.