If you can use a macro solution you can modify the export within.
The TAB character is CHR(9)
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Naomi" <Naomi@discussions.microsoft.com> wrote in message news:3901BA4B-D03D-455B-BC5A-5309522E93C6@microsoft.com...
> I wish to export from an excel spreadsheet file to a tab-delimited text file
> - WITH NO QUOTES around any of the entries. They are not necessary, because
> tabs - not commas are the delimiters. I was quite disappointed that from
> changing to the older version of excel, which had a configurable export
> function, where I could specify "no quotes please" to excel 2000, I cannot
> specify this.
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.