Excel 2007 is checking the file format to see if it conforms to the file
extension. Files with different extensions have different formats. That's
another reason you should not manually change file extensions. Let the
application, Excel in this case, create the file.

Tyro

wrote in message
...
On Jan 26, 8:42 pm, "Tyro" wrote:
Correction. When I referred to .csv files in my response, I meant .txt.

Tyro

"Tyro" wrote in message

...



You should not change file extensions like that. You're asking for
trouble. File extensions are used to indicate what type of file the file
is and what application created the file. Many applications create files
in formats that they understand and that other applications do not
understand. .xls files are created by Excel. Excel is also capable of
creating .csv files. Other applications can create .csv files too. .csv
files are intended to be used to allow easy transfer of data between
applications. The format of a .xls file and a .csv file are not the same
at all. That is why Excel is giving you the error message and it always
will. The proper way is to load your .csv file into Excel or import it
into an Excel worksheet and save it as an Excel workbook which will have
a
.xls extension.

Tyro

wrote in message
...
On Jan 26, 7:26 pm, "Tyro" wrote:
How did you change a .txt file to be saved with a .xls extension?
Also,
the
error mention you mention does not make sense.

Tyro

I changed the names of the extension using the command window (Run =
cmd). For example, at the c-prompt: "ren file1.txt file1.xls".

As for the error message, I retyped it as follows:"

The file you are trying to open, 'file1.xls', is in a different format
than specified by the file extension. Verify that the file is not
corrupted and is from a trusted source before opening the file. Do
you want to open the file now?"

When I click yes to open the file, the file opens up fine. I just do
not want to do this for the thousands of files that I have and was
wondering if there is a fix or anything I can do. Thanks for the
help.- Hide quoted text -

- Show quoted text -

Tyro...

I am still having this problem and just found out something
interesting. If I try to open the file in Excel 2002, I do not have
the error message prompt me in the beginning. However, if I use Excel
2007, I have the error message. Do you know why this would occur?