Run an ms word vba macro before a specific time

gmaxey · #3 11-13-2023, 07:22 AM

Graham shows you a method to run you macro if you start word before 1100 a.m.

Here is a method to run your macro once per day. Regardless of the the time you start word. It uses the registry to store variables.

Code:

Option Explicit
Sub AutoExec()
  If GetSetting("DailyAutoRun", "Settings", "Date") = vbNullString Then SaveSetting "DailyAutoRun", "Settings", "Date", Format(Date, "MM/dd/yyyy")
  If CLng(CDate(GetSetting("DailyAutoRun", "Settings", "Date"))) <= CLng(Date) Then
    SaveSetting "DailyAutoRun", "Settings", "Date", Format(DateAdd("d", 1, Date), "MM/dd/yyyy")
    MyMacro
  End If
lbl_Exit:
  Exit Sub
End Sub
Sub MyMacro()
  MsgBox "Test"
lbl_Exit:
  Exit Sub
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to navigate to specific point in line (Word 97)	Genericname1111	Word	13	10-06-2019 08:54 PM
Macro to select multiple sentences that contain a specific word	MauiTruss	Word VBA	7	10-03-2018 03:46 PM
Executing a Word macro only after a certain date & time	rdross51	Word VBA	4	07-07-2017 06:29 AM
Help with Macro to Save Word File as PDF in Specific Location	ekimisme	Word VBA	1	06-07-2017 10:40 PM
Excel Macro finding a specific word	ducky831	Excel Programming	3	09-17-2015 01:36 PM