S
suketus
Hi, I am receiving real time information from a trending database ever
5 minutes. I tried writing the Aut
pen macro to refresh the dat
every 5 minutes and update the chart. But it doesnt work. It refreshe
the data if i manually hit F9, but does not work on its own. Heres th
code i used.
Sub Autpen()
Application.OnTime Now + TimeValue("00:05:00"), "Autpen"
Calculate
End Sub
Can somebody please help!
5 minutes. I tried writing the Aut
pen macro to refresh the datevery 5 minutes and update the chart. But it doesnt work. It refreshe
the data if i manually hit F9, but does not work on its own. Heres th
code i used.
Sub Aut
pen()Application.OnTime Now + TimeValue("00:05:00"), "Aut
pen"Calculate
End Sub
Can somebody please help!