M
Mex
What is the difference between a capital .XLS and .xls extension to a file?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
There is no difference, as filenames (and extensions) are not case
sensitive in Windows/MSDOS.
Hope this helps.
Pete
sensitive in Windows/MSDOS.
Hope this helps.
Pete
B
Bob I
nothing
D
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.
upper case and lower case.
A worksheet comparison (using =) won't care. But VBA will.
M
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?
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?
D
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).
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).