|Subject:||Re: How does Excel make it's guess as to what type of file a CSV file is?|
|Posted by:||Jim Rech (jrre…@hotmail.com)|
|Date:||Tue, 1 Jul 2008|
CSV stands for comma separated values and it's a file type MS designated
many years ago. It is not fixed width and you cannot give that extension to
a fixed width file and declare it to be a CSV. You have to play by the
rules. Try another extension like TXT or PRN but then you'll have to go
through the Text Import Wizard or use a macro that uses the OpenText method.
"tharpa" <83433ai…@sneakemail.com> wrote in message
|I have a CSV file (not created with Excel.) If a user double-clicks
| on the file, Excel wrongly guesses that it's not a true Comma-
| Separated-Value file, but a fixed-width file. Thus to the user it
| will display incorrectly.
| How does Excel decide what to make it's first guess as to what kind of
| file a CSV file is?
| If I knew, I could probably tailor the file so Excel would guess
How does Excel make it's guess as to what type of file a CSV file is? posted by tharpa on Tue, 1 Jul 2008