workbook saveas function, xlText file format

[Guest]

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

 

[Tom Ogilvy]

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.

 

[Volker]

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

 

[Tom Ogilvy]

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