Solved: Expiration Date

[Djblois]

I want to hard code a date in my program that will shut it down if it is passed that date. I am trying to force people to update the add-in. This is the code that I have tried:

If Date > 6 \ 1 \ 7 Then

End If

I thought this should be so simple. I even tried figuring out what the number equivalant is for that date and that also didn't work.

[rory]

You could use:
If Date > Dateserial(2007,1,6) Then

[Djblois]

Thank you that worked

[mdmackillop]

I happened across this in VBA Help. Any use?
ExpirationDate Property