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
|