Thanks witek..........

I tried, but was unable to find it.

Vaya con Dios,
Chuck, CABGx3



"witek" wrote:

check Excel 2007 help for
XlFileFormat Enumeration



On 3/24/2010 1:24 PM, CLR wrote:
Thanks Hector, 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?

Thanks,
Vaya con Dios,
Chuck, CABGx3




"Héctor Miguel" wrote:

hi, !

Wondering if it is possible to programatically determine which version of Excel a file was created in?
I have folks send me a file and want some macros inserted, but don't tell me which version of Excel they are using.

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

hth,
hector.


.


.