ExcelBanter - xlExcel9795 Not Supported in 2007? 2003?

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.