HI.

I am trying to run a procedure but only on certain days of the week. Basically I have a workbook that runs some subs every morning before we start work (at 6:20am) and I use the Application.OnTime TimeValue("06:20:00"), "starter" to do this. The excel workbook is started last thing every night and finished by the time we arrive at work.

The problem I have is that I have no way of being able to open the workbook on a Friday and have it wait until 6:20am Monday to run the subs.

The computer that runs this will be doing nothing at all over the weekend. Any thoughts on how I could start this workbook on a Friday and have it wait until the day of the week is in Mon to Fri to run?

Thanks for your help