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

workbook saveas function, xlText file format
 

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

workbook saveas function, xlText file format
 

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

workbook saveas function, xlText file format
 

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