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.

I've been using Excel since before Excel 5/95 came out. I remember the
upgrade from Excel 4 to 5, and I remember when starting to use Excel 97 that
I sometimes had to use the 95/97 format for people who hadn't yet upgraded
to 97.

But anyway, Google can be your friend. I just Googled 'excel workbook format
95 97' and the second link contained some useful information right in the
first paragraph:
http://office.microsoft.com/en-us/or...381621033.aspx

"A dual file format saves two formats in a single file. This format is an
ideal solution for organizations that are upgrading gradually to Microsoft
Excel 2000. You can standardize your organization on the Microsoft Excel
97-2000 & 5.0/95 dual file format until all Excel 95 and Excel 5.0 users
have upgraded. Selecting the dual file format ensures that all Excel users
have a common file format with which to collaborate on shared workbooks
during the transition period."

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


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

I attempted to use the xlExcel9795 format because I am looking for a file
format that would cover Office 2000-2003. The help files in Office 2003
and
2007 were useless in this regard and the only place that had a remotely
understandable description of what each file format pertained to was the
SaveAs Dialog which had a "Microsoft Excel 97-2003 & 5.0/95 Workbook"
description. Made sense at the time.

Once I recorded the macro it became apparent that xlExcel8 was what I was
looking for in Office 2007. However I did not have a workable file format
to
use in Office 2003 to accomplish the same. I eventually settled for the
"default". Which appears to be readable in all the office versions we
require
prior to 2007.

But I am curious where you got your info on these file formats since they
are not well documented in the help files online or otherwise.

Thanks,

Jamie

"Jon Peltier" wrote:

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.