Why are you still using the 9795 format? This format really stores two
versions of the file (Excel 95 and Excel 97-2003) within the 9795 file,
bloating the workbook for no good reason. Do you really need the Excel 95
format for anything?

And yes, the 9795 format is gone from 2007.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jamie Carper" wrote in message
...
Hi Folks,

I found the constant xlExcel9795 to be in the VBA library for Office 2007
but I get an error when I attempt to use it as a file format property
value
in Workbook.SaveAs().

e.g. Workbook.SaveAs FileFormat:=xlExcel9795 FileName:="MyFile.xls"

When I record a macro and manually save the workbook as an Excel 97-2003
format the macro reveals the use of the constant xlExcel8 instead.

Has xlExcel9795 been deprecated if not why am I getting an error?

I was trying to find something common enough between all legacy versions
of
Office to programmatically save Office 2007 workbooks to remain downward
compatible. I thought xlExcel9597 would be my ticket. However even when I
attempt to use it in Office 2003, I get an Office Exception.

I have had better success with using no file format for legacy Office
versions (using the default) and then using the constant xlExcel8 when
working in Office 2007.