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