Vba: running a macro at a future date and time

[Nelson78]

Hello everybody.

I need to schedule a macro for 13/05/2018 at 20:00

In this workbook, I have to write something like this:

Private Sub program()
Application.OnTime TimeValue("20:00"), "xxxxxx"
End Sub

But:
1) how can I add the date?
2) could the date format be a problem?

Of course, the workbook has to remain open.

Thank's in advance.

 

[Nelson78]

Maybe with this I can avoid the matter about date format.

Application.ontime DateValue("May 13, 2018") + TimeValue("20:00:00"), "xxxxxx"

 

[Nelson78]

Maybe with this I can avoid the matter about date format.

Application.ontime DateValue("May 13, 2018") + TimeValue("20:00:00"), "xxxxxx"

Wrong.

Maybe the right one is::

Private Sub Workbook_Open()
Application.ontime DateValue("13/20/2018 8:00 pm"), "AutomaNeta"
End Sub