Results 1 to 2 of 2

Thread: Schedule a Macro to run in Access

  1. #1

    Schedule a Macro to run in Access


    I have a macro that I would like to run every weekday at 10am. Utilizing the task schedule in windows I can open Access, but I do not want to run the macro everytime the dB opens (autoexec).

    I have checked here I cannot get it to work

    Please help.

  2. #2
    VBAX Master geekgirlau's Avatar
    Aug 2004
    Melbourne, Australia
    In the Task Scheduler, you need to create a shortcut in the following syntax:
    • Full path to MSAccess.exe
    • Full path to your database
    • /x
    • The name of your macro in quotation marks
    "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "H:\MyDatabase.mdb" /x "MyMacro"

    If you do this (and don't name your macro "AutoExec") the macro will only run via the Task Scheduler, not each time you open the database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts