|
-
Aug 24th, 2004, 02:45 AM
#1
Thread Starter
New Member
Decimal separator when saving
Hi, (Excel 2000 English/VB v.6.0)
I'm a rookie when it comes to VB programming, so I hope you guys can help me!
I'm saving an Excel file using the following command:
[ActiveWorkbook.SaveAs Filename:="filaname.dat", FileFormat:=xlTextPrinter]
My problem is that the decimal separator comes out as a period/dot [.] instead of a comma [,] - even though it's displayed as a comma inside the sheet.
I've tried formatting the cell in different ways (standard, number, text etc...) but the output is still the same.
OS Regional Options: decimal symbol: [,] / digit grouping symbol: [none] / list separator: [-]
One requirement is that the output layout must be fixed text. I'm currently using "Selection.ColumnWidth..." to control this.
Any Ideas?
\oasno
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|