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

    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.

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

  2. #2
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    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.

    tc

Posting Permissions

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