Quote Originally Posted by Simply Me
I tried the breakpoint and step through it. it is not executing the higlighted part. it goes at once to end if
VB Code:
  1. If Date = ThisDay Then
  2.        [HL="#FFFF80"]MsgBox "test"[/HL]
  3.     End If

ThisDay and Yesterday are Strings - Days of the Week.

What are you trying to compare?