| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| run macro automatically when user changes the data poit in Pivot c | Charts and Charting in Excel | |||
| First Time Macro User--Stop Recording Toolbar | Excel Discussion (Misc queries) | |||
| Formula needed - automatically calculate session time totals for each user | Excel Worksheet Functions | |||
| Run a macro automatically at a certain time | Excel Worksheet Functions | |||
| Macro to record user name and date/time | Excel Discussion (Misc queries) | |||
Hybrid Mode
