| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Excel VBA as tab delimited text file without quotes
Today I use this code to save my sheet as a tab delimited text file:
ActiveWorkbook.SaveAs ActiveWorkbook.path & "\" & filnamn, FileFormat:=xlText It works for 90% of the data but some cell values get surrounded with quote marks? Why is this and how can I fix it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save delimited format, specify delimiter, remove quotes from text | Excel Discussion (Misc queries) | |||
| Japanese text lost when save as tab delimited text file | Excel Programming | |||
| Output space-delimited file with quotes around text? | Excel Discussion (Misc queries) | |||
| How can I save a file as a comma-delimited text file in Excel? | Excel Discussion (Misc queries) | |||
| Save file as text pipe delimited | Excel Programming | |||
Threaded Mode
