Hello,
I use the script below to process some data from a excel file. The output result must be saved in a TXT file. I facing issue when the .txt file is saved, all rows are wrapped with double quotes (initial data do not have quotation marks). How to prevent double quotes when saving? I tried so far to save as xlTextPrinter, partial works, no more quotes, but the file has mixed/unarranged rows.
Please Login or Register to view this content.
Last edited by zGod; 10-16-2021 at 12:27 PM.
Re: Saving As Txt file adds double quotes
Hello,
try the VBA constant xlText as FileFormat …
Thank you Marc for your reply, I tried as you suggest but same result:Attachment 751842Originally Posted by Marc L
Re: Saving As Txt file adds double quotes
As it well works as expected on my side so the bad in on your side …
Follow the top page yellow banner to attach your workbook.
Please find attached a sample file (some data has been modified because it contains confidential information) and also the .txt output file after saving as xlText format. I forgot to mention earlier all the data is located in first cell of the row.
Re: Saving As Txt file adds double quotes
According to your attachment replace your SaveAs codeline with this code where F is an Integer and Rw a Range :
PHP Code:F = FreeFile
Open c00 & ar(j, 1) & "_" & ar(j, 2) For Output As #F
For Each Rw In .UsedRange.Rows
Print #F, Rw.Text
Next
Close #F
► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄
Thank you very much Marc for your support. The code you provided is a breakthrough, but I have a small problem. Output files have no extensions and I can't open them. I need to rename all the files and put the .txt extension. Is there a solution here? If not, I can live with it, you've already saved me a lot of time.Attachment 751867
Re: Saving As Txt file adds double quotes
Thanks for the rep' !
Obviously Open c00 & ar(j, 1) & "_" & ar(j, 2) & " .txt" For Output As #F …
Thanks again Marc, it works great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks