Maybe you can steal some code and create your own macro that does it:

Earl Kiosterud's Text Write program:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

(In fact, Earl's has a lot of options--maybe you could just run with his.)

Dan T wrote:

The write to text file command exports in CSV, is there a way to change this so it writes to Tab Delimited?

--

Dave Peterson