vba - Creating a Macro in Excel which executes the other Macro every 2 seconds -


I have a macro called UpdateMacro that updates my database from my Excel

I want to create a macro called repeatmacro , where it executes UpdateMacro every 2 seconds and provides only to provide start and stop buttons Go Repeat Macro .

How can this be done?

applications for Google

example

To clear a predetermined process, you have to save the time at which it was determined) such as DtNextRunTime above), then use: 

  Applications. On Here is a sample VB module that you are going to start with startshield / stopshield:  
  Here is a sample VB module that you are going to start with: Start   
  Private m_dtScheduledTime as private m_lDelaySeconds as long Private m_bIs Scheduled Boolean Private Sub-Door (as) m_bIsScheduled = False '... Do Your Job' Once Again Start Starting StartSearch m_lDelaySeconds, " Doverker "And Sub Public Sub Start Shadule (By Val Delay Seconds Long) StopSedule M_LadyKScand = Dellacondus M_DTS ScheduledTem = Now + TimerCerial (0, 0, M_LeadlessSendense) application. Onetime M_DTSEiltrated Time, "Dupor", True M_BIS Scheduled = True End Sub Public Sub StopSedule () If m_bIs recommended then application . Onetime M_dtScheduledTime, "DoWork", false M_biIS scheduled = fail and end and end and

Comments

Post a Comment