hi, Chuck !
... but I need a little more help, if you please.
The file in question will have been created in one of the following versions of Excel
I just want to know which one
Excel 97
Excel 2000
Excel 2002
Excel 2003
Excel 2007
BTW, where did your list of numbers come from?
it seems that fileformat "56: xlExcel8" is used from xl-97 to xl-2003
as per this ms-kb document (BIFF excel fomat - C++ code):
HowTo: Determine the Version of a Microsoft Excel Workbook
http://support.microsoft.com/kb/q178605/
and, the list for version-number of "fileformat" comes from online help (xl-2007)
I'm sorry for not being able to go further in this matter :-(
regards,
hector.
__ previous __
when your version is surely above the one created the file...
try with: activeworkbook.fileformat
16: xlExcel2
27: xlExcel2FarEast
29: xlExcel3
33: xlExcel4
35: xlExcel4Workbook
39: xlExcel5 or xlExcel7
43: xlExcel9795
50: xlExcel12
56: xlExcel8