Save file as .csv then .txt?

[MOB]

Currently have an excel file where the first tab is in the correct format I need for saving as a .csv file.

I then have to open that .csv file using notepad and save it as a .txt file.

Our bank software will only import text files separated by commas.

Is there some vba that will automate this? I tried save as .txt but that is tab delimited rather than commas.

This is the info from the bank;

"File Structure - The payment file must be structured in a delimited format using a comma separated value (CSV) layout in a text file. Every field specified in the payment record must therefore be separated using a comma. "

TIA

 

[MOB]

Think I figured it out;

ActiveWorkbook.SaveAs Filename:= _
"c:\MyFile.txt", FileFormat:=xlCSV _
, CreateBackup:=False