Batch File running Access Macro/function

Hi all--

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...

Who is Participating?
peter57rConnect With a Mentor Commented:
Hi rz1224,
You put a Quit action as the last step in the macro.

rz1224Author Commented:

DOh!  Thanks for  your help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.