title: How do I automate a saved import in a macro in Access 2007?
body: <p>I have created a macro to run a saved import (a file imported from Excel into Access 2007).  When I run the macro, the saved import runs and the following happens:</p>
  
  <ol>
  <li>A "Manage Data Tasks" window pops up.</li>
  <li>I have to choose from the following options: <strong><code>Run</code></strong>, <code>Create Outlook Task...</code>, <code>Delete</code>, and <code>Close</code>. </li>
  <li>If I select <code>Run</code>, the next pop-up asks, "Overwrite existing table or query?"</li>
  <li>I have to choose: <strong><code>Yes</code></strong> or <code>No</code>. </li>
  <li>Another window pops up and says, "All objects were imported successfully." </li>
  <li>I have to click the <strong><code>OK</code></strong> button. </li>
  <li>I have to click the <strong><code>Clos</code>e</strong> button on the "Manage Data Tasks" Window.  </li>
  </ol>
  
  <p>Is there any way that I can automate all these button clicks if they are always going to be the same?  (The bold faced buttons are the ones that I'll always be clicking.)</p>