Dear Excellences,

we have an Excel table wich is modified via VBA code. This works
perfectly. At the end, this table has to be saved as *.txt file. When I
do this manually, I can retrieve the table easily. Especially, the
values in the last column, wich are comma (!) separated decimals, are
shown as comma separated decimals again. But when I let the code do the
saving for me with

ActiveWorkbook.SaveAs Filename:="C:\Temp\Cora Act" & ActMon & ".txt",
FileFormat:= _
       xlText, CreateBackup:=False

then these numbers are modified in a way, that the commas are
eliminated. The effect is then, that the numbers are multiplied by 10
times the places after the comma. In some cases, in additin the number
is shown as text and it can't be converted into a number again (e.g.
using =value(B10)).

Any hint how to persuade VBA to properly save the data is appreciated.

Thanks in advance
Udo