File extensions

[Mex]

What is the difference between a capital .XLS and .xls extension to a file?

 

[Pete_UK]

There is no difference, as filenames (and extensions) are not case
sensitive in Windows/MSDOS.

Hope this helps.

Pete

 

[Bob I]

nothing

 

[Dave Peterson]

But if you're writing code and comparing text, there is a difference between
upper case and lower case.

A worksheet comparison (using =) won't care. But VBA will.

 

[Mex]

Thnaks Dave

I've been receiving files with a CSV extension & it seems to make a
difference whether I save it to excel as a "5.0/95 Workbook" or "97-2000 &
5.0/95 Workbook" Can you explain why & does it really make a difference?

 

[Dave Peterson]

I don't think saving a .csv file as .XLS or .xls will make any difference.

There is a difference between the 5.0/95 workbook and the 97-2000 & 5.0/95
workbook.

The 5.0/95 workbook is an old format and anything that you use that's new to
xl97 would be lost.

The combination workbook essentially saves two copies of the workbook in the
same file. The old format and the new format is saved in one larger file
(almost double the size).

The only reason I would save as that combo style workbook is if I had to share
the same workbook with people who still run xl95 (not very likely) and with
people who use xl97+.

But neither of these fileformats has anything to do with the case of the
extension (.xls or .XLS).