Hi!
I'm using Excel to constantly run a macro with an "If" command to end the macro when a "switch" cell is equal to 0. Every X seconds values from a DDE link are coppied and pasted to a new location to create a record which can be viewed on a chart. After X "records" are created the file is "Archived" to a new sheet. This is working fine for me except for one issue...if the macro is left running as the system clock goes by midnight, the macro stops running.

I don't have any code that uses time, other than to insert the current time and date into a cell as part of each "record". Any idea what could be causing this, or how to get round this?

Cheers
PhilT