Scheduler Application.OnTime not working

[MonkeyHorse]

Hi, I hope one of you amazing people can help.

I have an excel spreadsheet that is constantly open and i want to auto run a macro at a certain time of day. I just can't get it to work when i'm testing it, see below.

The "TestTime" will be used as part of a bigger macro, but i thought it was visually easier to see if the macro has actually run when i asked it to. I have run the this macro separately via a button, and that seems to work.

I tried both using Sub and Private Sub.

Please Login or Register  to view this content.

[KOKOSEK]

Please Login or Register  to view this content.

[MonkeyHorse]

Thank you, sadly it is still not working. Is there anything else in specific i need to do, like save the macro in a specific place? Tried Module 1 on the workbook or close the vb window to make it work. Apologies i'm quite rusty at vb, i was only really active writing macros about 10 years ago,

[KOKOSEK]

This macro works fine.
I guess that you want to run this macro automatically, so put this:

Please Login or Register  to view this content.

into Workbook_Open code, then after opening file, macro will start automatically on 15:30:00.

[MonkeyHorse]

Thank you, i shall try that, i think that will work. would that repeat every day?

[KOKOSEK]

Do you want to leave open file constantly 24/7?