Saveas surrounding text with double quotes

Asked Jun 01 '21 at 04:19

Active Jun 01 '21 at 08:50

Viewed 195 times

I have a macro that saves data to an external file. It uses this command:

ActiveWorkbook.SaveAs Filename:=Filename, FileFormat:=xlUnicodeText, CreateBackup:=False

My problem is that most of the data that has been saved is surrounded by double quotes. But few pages are saved without the double quotes.

It is the same macro that saves the data so why do some files not have the double quotes? How can I make all pages save without double quotes?

UPDATE:

Every cell in every sheet contains commas. The data in Excel cells is not surrounded by double quotes. I use Excel to build SQL queries. But, some of the sheets still save to file without double quotes. What sheet setting should I look for, if any?

edited Jun 01 '21 at 08:50

asked Jun 01 '21 at 04:19

CharlesEF

When you save as `FileFormat:=xlUnicodeText`, any text which has comma will be surrounded by double quotes. – Siddharth Rout Jun 01 '21 at 05:26
https://stackoverflow.com/questions/11501531/saving-a-excel-file-into-txt-format-without-quotes – Siddharth Rout Jun 01 '21 at 05:28
@SiddharthRout, thanks for the reply. Please see my update in the question. – CharlesEF Jun 01 '21 at 08:52
Did you go through the link that I posted above? Because that has your solution – Siddharth Rout Jun 01 '21 at 09:06
@SiddharthRout, Yes, but I don't want another macro to fix the problem. Excel does what I want I just need to figure out why it works both ways with 1 macro. I will re-read the article again. Thanks for your input. – CharlesEF Jun 01 '21 at 17:29

Saveas surrounding text with double quotes

0 Answers0