Batch File Help?

[bonehead]

Greetings,

Apologies in advance for the cross-posting. I'm not certain which is the
best group to post this to.

I don't use cmd.exe very much and I don't write batch files very often.
Hopefully this is a simple question with a simple answer.

Here is a batch job which I can run at will, or as a scheduled task. The
batch job starts MS Access, opens the specified file, and executes the
specified macro (which, in turn, invokes a VB function in a module):

"C:\Program Files\Microsoft Office\Office11\msaccess.exe"
"C:\MyFilePath\MyDatabaseName.mdb" /X MyMacroName
exit

Note that wrapping in certain newsreaders may make it appear that there
is a carriage return after the call to msaccess.exe, but this is not
actually the case. The only carriage return is before the exit command.

Can I modify this so that after the macro executes, the .mdb file
closes, MS Access exits, and the cmd shell closes? Currently I have to
close MS Access manually to return the focus to the shell, then the
shell performs the exit command and closes on it's own.

Suggestions?

 

[Gary''s Student]

Consider including the commands to close the file and exit the application
within the macro rather than within the batch file.