I am trying to place an order at 10am everyday, so in VBA, I type these lines:
Sub SetTime()
Application.OnTime TimeValue("10:00:00"), "PlaceOrder"
End Sub
Sub PlaceOrder()
******
******
End Sub
The above "PlaceOrder" procedure can be executed successfully if I run it separately. The problem...