Saving Excel worksheet into text not formatting correctly

[rmobley232]

I am pulling data into Excel through an ODBC code using SQL code:
SELECT CONCAT (a.Material,',',c.New_Pattern) as RP_Unassign FROM Weekly.Assign;

The data pulled into Excel is formatted exactly as it needs to be:

RP_Unassign

30UN96,GUSSUP202011

36UN72,GUSREG202011

Once the data has been updated on a weekly basis, I save this tab as tab delimited .txt for final execution. When I do, it places quotations around my data, which I can't have, is there something with the CONCAT code creating these quotations when I save as a text file?
RP_Unassign
"30UN96,GUSSUP202011"
"36UN72,GUSREG202011"

 

[johnnyL]

Please post the vba code that you are using.

 

[rmobley232]

Here is the code, I have modified it to save it with the date I run the code (for example if I saved it today would have the format 051221:
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\br4rkm\OneDrive - W.W Grainger, inc\Desktop\Region Pattern Unassign " & Format(Now(), "mmddyy") & ".txt" _
, FileFormat:=xlText, CreateBackup:=False

 

[johnnyL]

Try FileFormat:=xlTextPrinter instead of FileFormat:=xlText

also

If you are using 'write' in your vba code, change those to 'Print"