title: How can I automate importation and formatting of a text file?
body: <p>Excel 2007:</p>
  
  <p>I have an app which outputs several rows, with pipe delimiters, into an ascii text file on a quarterly basis.</p>
  
  <pre><code>row example:  NAME|ADDRESS|CITY|DESCRIPTION|AMOUNT|
  </code></pre>
  
  <p>I'm currently importing this file on a manual basis into a blank spreadsheet, using the following commands:</p>
  
  <blockquote>
    <p>Data, Import from Text, {Wizard Step 1} Delimited, {Next}  {Wizard
    Step 2} Delimiter Type = Other = |, Text Qualifier = None, {Next}
    {Wizard Step 3} Column Format = General, {Finish} {Accept} {File, Save
    As, FileName}</p>
  </blockquote>
  
  <p>I would like to automate all these manual steps when opening up a blank sheet.</p>