My app has the Excel 11.0 reference and is running on a pc with 9.0.

(11.0 refernece is excel.exe. i used to use excel.olb what happened
to that
library in this release)

How do I save down?

When I code the SaveAs I pass a filename and xlExcel9597 as the
format. My app quits and excel is still running. It does not fall
down to my error handler. It goes to Case 10,9,7 and just stops:


Select Case m_intVersion
Case 11
m_objWorkbook.SaveAs Filename:=m_strExcelFileName
Case 10, 9, 7
m_objWorkbook.SaveAs Filename:=m_strExcelFileName,
FileFormat:=xlExcel9795, _
Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False, CreateBackup:=False
Case 5
m_objWorkbook.SaveAs Filename:=m_strExcelFileName,
FileFormat:=xlExcel5
Case Else
m_objWorkbook.SaveAs Filename:=m_strExcelFileName,
FileFormat:=xlExcel5
End Select

I thought I would be able to save down. must be missing something but
searches have not turned up anything.

Thanx...Jim