Problem with Auto_Open function
 

Hi, I am receiving real time information from a trending database ever
5 minutes. I tried writing the Auto_Open 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 Auto_Open()
Application.OnTime Now + TimeValue("00:05:00"), "Auto_Open"
Calculate
End Sub

Can somebody please help!

--
suketu
-----------------------------------------------------------------------
suketus's Profile: http://www.excelforum.com/member.php...fo&userid=3594
View this thread: http://www.excelforum.com/showthread.php?threadid=55730