I am trying to copy DDE data froom one cell to another in a workbook on a
daily basis. I used the Ontime function in an Auto_Open() sub. When I open
the workbook, the Ontime function runs the first day and does in fact copy
the data. It does not run on subsequent days unless I close the workbook and
reopen it. I may have the Ontime function in the wrong place or I may have to
do some additional programming to reschedule susequent Ontime Events. Does
anyone out there have any ideas? Thanks!