Hi, <You have helped me twice but I dont know your name yet
I am thankful for your reply and solution but I opted Alan's
solution.
Hope to see u soon.

Gary''s Student wrote:
Try:


Sub gsnu()
Dim d1 As Date
Dim d2 As Date
d1 = Date
d2 = "February 12,1997"
If d1 < d2 Then Exit Sub
MsgBox ("the date matches")
End Sub
--
Gary's Student


"ashish128" wrote:

Hello All,
I have a macro which works perfectly but I want to add a condtion
which will compare the current system date with a date (a static date
written in code itself so no dynamics required). If the dates are same
then the code should run further else it should terminate my macro.

I dont have knowledge of VBA so please detail the process to wrap my
existing macro into a Condition.
In C/C++ I would have written
if(today()=8/30/2006) //////// Please ignore syntax faults if any.
{
execute true code // current macro code
}

Please help.