Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006

    Unanswered: Bat to run VB codes via MS Access

    I have a macro that run VB code. If I manualy run the macro named runEmailExtract, the code ran fine. I created a bat below and use window scheduler to runs weekly, the VB code doesn't run unless I click play button. Below is my bat, does anyone know what's wrong? Thanks.

    "C:\Program Files\microsoft office\Office11\MSACCESS.EXE" "C:\Documents and Settings\trantuye\Desktop\MetricsSQL.mdb" /x runEmailExtract

  2. #2
    Join Date
    Apr 2004
    outside the rim
    Instead of invoking the macro from the command line, convert the macro to code and place it in the "on open" even of a start up form.

    That should fix it up for you.


Posting Permissions

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