2007 & 2003

Note to the file - so to speak:


Even if one changes Excel 2007's default file SaveAs format, when
2007
closes, it saves files like Personal.xls as a 2007 file format
without
the new extension .xlsx


My point, I still must save files in 2003 for other's who do not have
2007.


If I copy Personal.xls in the Excel StartUp Directory to a 2003
platform, Excel 2003 does not recognize the file format. (The file
size is about 50% of the original 2003 file size - which is a strong
hint that the file is in the new XML format)


Therefore, I created a macro to save Personal.xls in the 2003 format
in a different directory of my C drive:


Workbooks("PERSONAL.XLS").SaveAs "C:\Excel Information
\Personal.xls", FileFormat:=xlExcel8


EagleOne

Even if one changes Excel 2007's default file SaveAs format

This applies only to new, unsaved files.

--
Jim
"EagleOne" wrote in message
ups.com...
| 2007 & 2003
|
| Note to the file - so to speak:
|
|
| Even if one changes Excel 2007's default file SaveAs format, when
| 2007
| closes, it saves files like Personal.xls as a 2007 file format
| without
| the new extension .xlsx
|
|
| My point, I still must save files in 2003 for other's who do not have
| 2007.
|
|
| If I copy Personal.xls in the Excel StartUp Directory to a 2003
| platform, Excel 2003 does not recognize the file format. (The file
| size is about 50% of the original 2003 file size - which is a strong
| hint that the file is in the new XML format)
|
|
| Therefore, I created a macro to save Personal.xls in the 2003 format
| in a different directory of my C drive:
|
|
| Workbooks("PERSONAL.XLS").SaveAs "C:\Excel Information
| \Personal.xls", FileFormat:=xlExcel8
|
|
| EagleOne
|