• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 430
  • Last Modified:

Automatically run Access macro from a shared drive

The Access macro that I'm trying to automatically execute using a batch file is on a network/shared drive.
The problem is, Access doesn't automatically close after the macro executes.
Any idea on how to do this in a batch file/DOS command?
0
kris_sk2012
Asked:
kris_sk2012
  • 2
1 Solution
 
fhlio_adminCommented:
Why not add a Quit command to your macro or if you use that macro for other purposes, create a new macro that runs the requested macro and then quits?
0
 
kris_sk2012Author Commented:
Exactly - so what's the quit command for access and excel?
0
 
fhlio_adminCommented:
It is a command that is in the list when designing a macro.  The attached image shows Access 2010.  The option in 2010 is "QuitAccess".  The option before is "Quit".  This exits Access.  The option associated with this command is a saving option.

Macro-Quit
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now