Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro fire at given time, through command prompt
Hi
We have a macro that does some formatting on a sheet. Is there any way of prompting this macro to fire from the windows command prompt, and to make it fire automatically once a day? once a day, a file is deposited in the same location which is then amended. The process is the same everytime, we'd just liek ti to sort itself out without intervention TIA tim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro fire at given time, through command prompt
here is a sub i use to start a macro (macAStart) at 5 am
each morning(while i'm home still in bed)so that morning reports will be on the printer when i get to work. The whole routine launches 10 different macros in as many files. it skipps sat and sun. Sub macALaunchMR() If Weekday(Now()) = 6 Then '1 = Sunday, 2 = Monday, 3 = Tuesday, ect Application.OnTime Now() + 2.5 + TimeValue ("00:00:03"), "macAStart" Else Application.OnTime TimeValue("05:00:00"), "macAStart" End If End Sub look up the ontime event in help for more details -----Original Message----- Hi We have a macro that does some formatting on a sheet. Is there any way of prompting this macro to fire from the windows command prompt, and to make it fire automatically once a day? once a day, a file is deposited in the same location which is then amended. The process is the same everytime, we'd just liek ti to sort itself out without intervention TIA tim . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to fire upon opening file | Excel Discussion (Misc queries) | |||
Fire Macro from Cell Change | Excel Worksheet Functions | |||
Data Val list Excel 97 fire macro | Excel Discussion (Misc queries) | |||
Date/Time Picker Event Won't Fire | Excel Programming | |||
keypress to fire command button | Excel Programming |