How to avoid extra double qoutes when saving sheet as text file?

[PeeterP]

I have a VBA that saves the sheet as text file, sheet has only 1 column where each cell has youtube embede code ike this:

********> width="560" height="315"  src="https://www.youtube.com/embed/JbXhEozJZzg?rel=0&controls=0&showinfo=0"  frameborder="0" allowfullscreen>*********>

But when i save that sheet as text file, excell will add double qoutes to each existing double qoutes + 1 at the beginning and 1 ad the end of each row reslting each row to look like this:

"********> width=""560"" height=""315""  src=""https://www.youtube.com/embed/pE7ODk6vtEc?rel=0&controls=0&showinfo=0""  frameborder=""0"" allowfullscreen>*********>"

Part of vba that saves the file is this:

ActiveWorkbook.SaveAs Filename:="youtube.txt", FileFormat:=xlText, _
CreateBackup:=False

How can i avoid this and keep the original format that i have in excell sheet?

NOTE: Forum engine has removed iframe html tags from my code and replaced them by stars.

 

[PeeterP]

OK i was digging little bit on google and found the answer, here is how to save the text files without getting any extra qoutes:

<code>ActiveWorkbook.SaveAs FileName:=myFileName, FileFormat:=xlTextPrinter, CreateBackup:=False</code>