I need to save a file as a Tab-delimited text file and as you may be aware any fields that contain punctuation (line breaks, quotes, commas and periods) are saved by Excel with quote marks around the contents. There is no way to disable this function.
I need the file to be saved without these quote marks.
I found this VBA script that supposedly will save Excel spreadsheets as txt files without these added quote marks:
Unfortunately when I run the script I get an error-
"Run-time error '13':
Type mismatch"
on the line:
file.WriteLine Join(WorksheetFunction.Index(arr, r), vbTab)
Any help would be greatly appreciated!
Bookmarks