Dynamic counter for use in excel

[JoltinJoe]

I've got DDE links in excel and I trying to figure out if it is possible to set up a counter that will count the number of times the cell returns a specific value throughout the day.

[kadghar]

if you wont open/close the excel during day, use a simple variable (integer or double), or store the value in some excel's cell

otherwise, create a text file to store the results using OPEN/FOR/AS

HTH