title: Excel Export as Unicode Pipe Delimited
body: <p>Right now I'm trying to save an excel sheet with VBA as a pipe delimited unicode file with a .txt extension.</p>
  
  <p>I've figured out how to save it as unicode with code as follows</p>
  
  <pre><code>ActiveWorkbook.SaveAs FileName:=FileName, _
  FileFormat:=xlUnicodeText
  </code></pre>
  
  <p>But this will save it as tab delimited.  I can't seem to find an option with MSDN, as their page on <a href="http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.xlfileformat.aspx" rel="nofollow" title="MSDN FileFormat Cheat Sheet">FileFormat</a> isn't very helpful.</p>