View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
R Avery R Avery is offline
external usenet poster
 
Posts: 220
Default Saving to Text problems

Inconsistently, but fairly often, when I save an Excel file to tab
delimited text, it will save certain cells (which do not contain tabs in
their value) with quotes surrounding their value.

How do I change this?

Do i have to open up the file with FSO, and replace all "\n""" or "\t"""
with "\n"? Or is there a better way?