workbook saveas function, xlText file format

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" <[email protected]> wrote in
message news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> Add to your SaveAS object the property Local:=True
> Regards Volker
>
>