hi
i think the ontime method might do better.
see this site for more details
http://www.cpearson.com/excel/OnTime.aspx
regards
FSt1
"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) Or Now <
TimeSerial(16, 0, 0) Then {It does not work!}