<div>
Same effect, it adds quotes around everything.
</div>


Same effect, it adds quotes around everything.

<div>
Jeroen,<br />
<br />
That worked. &nbsp;I had to modify the vDelim line and set it to null since I did not want tabs in my output.<br />
<br />
Thank you for your help, I guess I should have searched a little harder in EE!<br />
<br />
Joe
</div>


Jeroen,

That worked.  I had to modify the vDelim line and set it to null since I did not want tabs in my output.

Thank you for your help, I guess I should have searched a little harder in EE!

Joe

<div>
Thanks Joe,<br />
glad to hear it worked.<br />
Searching EE is the first place to start :)<br />
regards,<br />
Jeroen
</div>


Thanks Joe,
glad to hear it worked.
Searching EE is the first place to start :)
regards,
Jeroen

<div>
<div class="content wysiwyg-content">
I import a t ext file (fixed width although records have commas) for processing in Excel. &nbsp; Due to changes in how the processing works, the file is imported into a workbook where the code is at. &nbsp; After processing, when I save the sheet back to text format (I have tried all.txt options), it adds quotation marks around the text where it is separated by commas. &nbsp;I noticed that you just open the file as fixed width and save it, it does not add the quotes. &nbsp;This only happens when I open the file, copy it to a new workbook and try to save it from there. &nbsp;Does anyone know how to prevent Excel from adding quotes to the records?<br />
<br />
Thanks,<br />
<br />
Joe
</div>
</div>


I import a t ext file (fixed width although records have commas) for processing in Excel.   Due to changes in how the processing works, the file is imported into a workbook where the code is at.   After processing, when I save the sheet back to text format (I have tried all.txt options), it adds quotation marks around the text where it is separated by commas.  I noticed that you just open the file as fixed width and save it, it does not add the quotes.  This only happens when I open the file, copy it to a new workbook and try to save it from there.  Does anyone know how to prevent Excel from adding quotes to the records?

Thanks,

Joe

Excel adds quotation marks to comma separated text during save operation

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.