Logging data with DDE link

Hi everyone,

Need help here. I am using excel 2002 to connect to another application using DDE. The data I am getting is constantly changing. I was wondering is it was possible to log this data say every 1 minute into another sheet? Please advice thank you.

whtrader

Hi,

Take a look at Chip's solution

http://www.cpearson.com/excel/ontime.htm

HTH
Carim