How compare the actual date and time with a variable create in VB macro?

[#1]

Hi all,

How compare the actual date and time with a variable create in VB macro?

I tried this code, but the result is always "exit" independing what my test time.

Sub testa_horario()

vDateAtual = now()

vDate = date()&" 11:00:00"

if vDateAtual > vDate then

msgbox("run macro II")

else

msgbox("exit")

End if

End sub

Thanks!

[stigchel]

To assign variables use Set (or Let) so:

Let vDateAtual = now()

[stigchel]

For the difference between Let and Set see e.g.

use of SET and LET in script

[#4]

Thank you, but I need create and compare the variables in a macro, no in the load script.

[Anonymous · Accepted solution]

This should do it:

Sub testa_horario()

vDateAtual = Now()

vDate = cdate(date()&" 11:00:00")

if vDateAtual > vDate then

msgbox("run macro II")

else

msgbox("exit")

End if

End sub

[#6]

It works! Thank you!