I've got the following problem.
I create a new workbook (single sheet) processing an original workbook.
The "new" workbook is very simple: 3 columns, a description and two numbers
columns.
I get the problem when I save the new workbook via VBA with the saveas
function as in follows
new_workbook.saveas Path, xlText

The execution produces a file where decimal separator is always "." despite
regional settings.
The strange thing is that if I "save as" the workbook from Excel main menu,
selecting TXT format, the resulting file is correct with decimal separator
that follows regional settings.

I get the same problem with Excel 2000, XP, 2003.
Format of the number cells doesn't affect the result.
Any suggestion?

Regards

Massimo

In xl XP, 2003, go into Tools=Options=Internation tab and define your
decimal separator.

I believe this will change the behavior in VBA. In xl2000, I think you
don't have this option.

You might want to write the file yourself using low level file IO.

--
Regards,
Tom Ogilvy

"Massimo Bassini" wrote in
message ...
I've got the following problem.
I create a new workbook (single sheet) processing an original workbook.
The "new" workbook is very simple: 3 columns, a description and two
numbers
columns.
I get the problem when I save the new workbook via VBA with the saveas
function as in follows
new_workbook.saveas Path, xlText

The execution produces a file where decimal separator is always "."
despite
regional settings.
The strange thing is that if I "save as" the workbook from Excel main
menu,
selecting TXT format, the resulting file is correct with decimal separator
that follows regional settings.

I get the same problem with Excel 2000, XP, 2003.
Format of the number cells doesn't affect the result.
Any suggestion?

Regards

Massimo

Add to your SaveAS object the property Local:=True
Regards Volker

Good one. I forgot that was added in xl2002 and later - knew something was
<g

--
Regard,s
Tom Ogilvy

"Volker" wrote in message
...
Add to your SaveAS object the property Local:=True
Regards Volker