Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
| Search | Today's Posts | Mark Forums Read
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 3rd, 2007, 11:45 AM
Registered User
 
Join Date: Jun 2007
Location: Cairo, Cairo, Egypt.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Automatically Event Repeat in Excel VBA ? plz help


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
 
Old July 4th, 2007, 06:37 AM
Friend of Wrox
Points: 3,060, Level: 23
Points: 3,060, Level: 23 Points: 3,060, Level: 23 Points: 3,060, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2005
Location: , , .
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

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




Similar Threads
Thread Thread Starter Forum Replies Last Post
Code works in Excel VBA but not Access VBA fossx Access VBA 2 May 21st, 2007 08:00 AM
run automatically...help plz lom2pac Access 2 August 7th, 2006 10:42 AM
Automatically attach Excel spreadsheet to Email nbaj2k Excel VBA 3 August 1st, 2006 12:15 PM
Converting excel data to Access using excel VBA ShaileshShinde VB Databases Basics 1 April 26th, 2006 07:57 AM
Excel VBA to SQL & back to VBA edesousa Excel VBA 1 June 1st, 2004 02:39 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.