| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run macro at specified time
When you reschedule, you'll need to calculate the next Monday, Tuesday,
Saturday or whatever day you want the macro to run. Be aware that OnTime does not persist after you've closed Excel. The macro only runs if Excel is running too. You need to reset OnTime every time you open the workbook. Rob "mushy_peas " wrote in message ... how about days of the week for example i want to run a particualr marco at diff times in the days depending if its Mon - Thurs, and another for Sat-Sun --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro / function text time to 24hr excel time passed midnight fortotaling hr's | Excel Worksheet Functions | |||
| I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
| I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
| How do I set macro to run at specified time? | Excel Worksheet Functions | |||
| Can I get a macro to run at a certain time of day? | Excel Discussion (Misc queries) | |||
![Rob van Gelder[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
