Automatically run a macro in time that user wants
 

Hi
I have an excel that contains a macro and I want that macro to run
automatically at the time I want. For example I have my pc open and I want to
run automatically this macro at 10:00 am. Without to need to press any
button. Is there any way to do that from Excel code?? Or is there any other
way??
Please let me know!

Thanks a lot

Automatically run a macro in time that user wants
 

use
APPLICATION.ONTIME

Help shows how

Sub StartTimer()
Application.OnTime TimeSerial(8, 15, 0), "WakeUp"
End Sub
Sub WakeUp()
MsgBox "Time to Go!"
End Sub


"Kyriaki" wrote:

Hi
I have an excel that contains a macro and I want that macro to run
automatically at the time I want. For example I have my pc open and I want to
run automatically this macro at 10:00 am. Without to need to press any
button. Is there any way to do that from Excel code?? Or is there any other
way??
Please let me know!

Thanks a lot

Automatically run a macro in time that user wants
 

I don't do this by keeping Excel open. Rather, within Excel I create an
Auto_Open macro that will run when the file is opened (sign it using the
selfcert.exe program, and indicate that you trust yourself; this avoids
security warning dialogs). Then put the Excel file on a Windows Scheduled
Task, and use the scheduler to control when the macro runs.

"Kyriaki" wrote:

Hi
I have an excel that contains a macro and I want that macro to run
automatically at the time I want. For example I have my pc open and I want to
run automatically this macro at 10:00 am. Without to need to press any
button. Is there any way to do that from Excel code?? Or is there any other
way??
Please let me know!

Thanks a lot