| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to set time within macro?
Does anyone have any suggestions on how to set time for processing the code?
I would like to add a condition that allow process the code before 4 pm, Does anyone have any suggestions on how to do it? Thanks in advance for any suggestions Eric If FileDateTime(PathFileName) Date + TimeSerial(8, 0, 0) Then {It is working!} I would like to add another condition that allow process the code before 4 pm, which I tried and show below, but it does not work. If FileDateTime(PathFileName) Date + TimeSerial(8, 0, 0) Or Now < TimeSerial(16, 0, 0) Then {It does not work!} |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to set time within macro?
Instead of Now try
Time < timeserial(16,0,0) -- Jacob "Eric" wrote: Does anyone have any suggestions on how to set time for processing the code? I would like to add a condition that allow process the code before 4 pm, Does anyone have any suggestions on how to do it? Thanks in advance for any suggestions Eric If FileDateTime(PathFileName) Date + TimeSerial(8, 0, 0) Then {It is working!} I would like to add another condition that allow process the code before 4 pm, which I tried and show below, but it does not work. If FileDateTime(PathFileName) Date + TimeSerial(8, 0, 0) Or Now < TimeSerial(16, 0, 0) Then {It does not work!} |
| 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 | |||
| Macro elapsed time bar (same as download time elapsed bar) | Excel Programming | |||
| time and auto macro run by setting time | Excel Programming | |||
| Help with Macro to Convert Date/Time to Time Only | Excel Programming | |||
| excel - macro - automatic initiation of a macro at a pre-specified "system time" | Excel Programming | |||
Linear Mode
