Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel workbook SaveAs question
I am using _Workbook::SaveAs to make a csv copy of an XLS file (using the
file format Excel::xlCSVWindows). The problem I've run into is, numeric cells in the Excel file that are formatted to use thousands separators copy that formatting to the CSV file (one of the few bits of formatting that DO get copied). So a number without thousands separators is 1000 in both the XLS and CSV files. A number with thousands separators is 1,000 in the XLS file, and "1,000" in the CSV file. This isn't so tragic, except for a few things: if you have a text field with 1,000 in it, it looks exactly the same in the CSV file as a numeric field with thousands separators ("1,000"), making it impossible to distinguish between them. Because of this, modifying our CSV parser to handle something like "1,000" is somewhat less than ideal. So my question is, is there a way to tell Excel NOT to format over the thousands separator on SaveAs? I suspect there is not, but thought I'd ask anyway. Thanks, Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 question involving SaveAs to .XLS | Excel Discussion (Misc queries) | |||
Calling workbook.saveas depending on excel version | Excel Programming | |||
Excel workbook.saveas freezes program | Excel Programming | |||
Using custom template with Excel.Workbook.SaveAs | Excel Programming | |||
Error Excel: 1004 SaveAs method of Workbook class failed | Excel Programming |