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!

OnTime is a one time event. If you want it to recurr the macro set to run
Ontime must set it again.

Sub SetOnTime()
Application.OnTime SomeTime, "RunByOnTime"
End Sub

Sub RunByOnTime()
''Doing my Thing
Application.OnTime NextTime, "RunByOnTime"
End Sub

--
Jim
"BillM" wrote in message
...
|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!

Thanks for the pointer.

"Jim Rech" wrote:

OnTime is a one time event. If you want it to recurr the macro set to run
Ontime must set it again.

Sub SetOnTime()
Application.OnTime SomeTime, "RunByOnTime"
End Sub

Sub RunByOnTime()
''Doing my Thing
Application.OnTime NextTime, "RunByOnTime"
End Sub

--
Jim
"BillM" wrote in message
...
|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!