Sub Xlstotxt()
'
' Xls-to-txt Macro
' function: open an EXCEL file with n columns data (amounts)
' export a CSV file (tab is seperator)

ChDir "C:\users\Name\Work"
Workbooks.Open FileName:="C:\users\Name\Work\C-POLMRP.XLS"
Cells.Select
Selection.Columns.AutoFit
Range("A1").Select
ActiveWorkbook.SaveAs FileName:="C:\users\Name\Work\C-POLMRP.TXT", _
FileFormat:=xlText, CreateBackup:=False
ActiveWindow.Close


End Sub



Problem: Difference in results doing the job myself and leaving it to the macro
The macro creates amounts with a period. (125.50)
I need amounts with a comma. (125,50)
With statement do I need in VB tot resolve this problem?