Pipe Delimited file in VBA Code - Do I have to mess with the Control Panel each time ?

[flynavy]

I have a VBA Macro that creates 50 or so CSV files (comma delimited) for our different customers. Here is a simple line I use in the Macro:

 ThisWorkbook.SaveAs Filename:=SaveToDirectory & “\filename nn.csv”, FileFormat:=6

Now I have one customer who wants a Pipe Delimited file.

Is there a simple way to do this in the existing VBA code without using the Control Panel, Region and Language, Additional Settings? That seems almost 100% impractical!

 

[Joe4]

There are some threads on here that will show you how to use VBA code to do that. Here are a few:
https://www.mrexcel.com/forum/excel-questions/55769-export-pipe-delimited-file.html
https://www.mrexcel.com/forum/excel...-manually-saveas-but-not-when-i-use-code.html