Hit Enter button Command in VBA at specific time

[Mehmud Khan]

Is there any option available to hit Enter button command in VBA at specific time ?


Thanks in Advance....
Regard!
Mehmud

 

[Ramesh]

You can use Application.OnTime() method of VBA..but in order to have this method executed, you need to have that workbook where this code is written is in opened or using the Task Scheduler of windows open the file at specific interval and call the method to execute your code under the workbooks_Open() event..