Excel 2007 : Saving DDE Daily Data

[Kiwi06]

Gidday

How do you auto update and save the ohlc from the current day in to excel.
Using the DDE Sample


So at 00.00.01 the new Open (Bid) will be saved.and at 00.00.00 of the same day the High, Low and Close (Bid) will be saved.

I would like to create a daily ohlc data base.

Is this possible and how do you do it.


Thanks

Kiwi