Hello All ;

I want VBA Code that can help me for saving
Excel Cell Value every 60 seconds in Access DB
as a new row in the table .

and I want this action begins in a fixed time like 11:00 AM
and It finished in 2 PM . ( Stop to save Cell value in DB every min. )

Is there any VBA Code that can make that in Excel ?

Thank you so much





Jake Anderson

You can do it using two steps

1. To use the Ontime method to start and stop the timer

Application.OnTime TimeValue("11:00:00"), "StartProc"
Application.OnTime TimeValue("13:00:00"), "EndProc"

2. In the start proc you can give the necessary code for backing up data and then increment the OnTime Event Counter

Good luck

Shasur

http://www.dotnetdud.blogspot.com