Batch File running Access Macro/function
Posted on 2006-05-01
I have a batch file I'd like to schedule that runs a macro in an access application. The macro in turn calls a function which exports some task information from the local instance of outlook. My .bat is pretty simple:
"C:\Program Files\Microsoft Office\Office11\msaccess" "C:\SP\SPlans.mdb" /x TaskImpy
It seems to work just fine...appropriate records are written to the access table. However, the cmd window remains open. Am I missing something? I'd like to figure out how to close the access app via the batch file as well, but I can seem to get to that step...