Cast the macro values to integers so that integer rather than string comparisons will be performed:
NUMBER_OF_FAILED_PROJECTS=CLng(Project.Macros("NUM BER_OF_FAILED_PROJECTS").Value)
CURRENT_COMPILE_NUMBER=CLng(Project.Macros("CURREN T_COMPILE_NUMBER").Value)
COMPILE_TIME=CLng(Project.Macros("COMPILE_TIME").V alue)
...
|