Problem in running the macro on a pre-specified time.

[ThrottleWorks]

Sir, I want to run a macro at a specified time.

I must mention, I got the code from this forum only (Thanks Chandoo).


The code worked for few days but it has stopped working all of a sudden.

Can someone please help me finding what is the issue here.


Code I am entering


Private Sub workbook_open


Application.ontime time value (“18:30:00”), “Back_Up”


End Sub


Sir, at the specified time which is 18:30, excel application is open on the PC, do need to keep the macro file open as well.

The private macro & “Back_up” macro are in the same file.


Thanks - Sachin

 

[Luke M]

Yes, the file w/ the macro would need to be opened. Note that since you've got this in the Workbook_Open event macro, multiple openings of the workbook before the 18:30 time mark could cause complications as it's going to create a "log" of OnTime events that need to be run.

 

[ThrottleWorks]

Luke Sir, thanks lot for the help,


Once again thanks for your great support & valuable time.


I am still trying it, caught with some another urjent work.


sorry for the late reply


Have a nice day (Week-End).