View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Héctor Miguel Héctor Miguel is offline
external usenet poster
 
Posts: 434
Default Which version Excel created file?

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