Which version Excel created file?

[CLR]

Hi All.......

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.

TIA
Vaya con Dios,
Chuck, CABGx3

 

[Héctor Miguel]

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.

 

[CLR]

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

 

[witek]

check Excel 2007 help for
XlFileFormat Enumeration

 

[CLR]

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

I tried, but was unable to find it.

Vaya con Dios,
Chuck, CABGx3

 

[Héctor Miguel]

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 __

 

[CLR]

Ok, thanks anyway Hector.......that C++ stuff is out of my league.

Vaya con Dios,
Chuck, CABGx3

 

[JLGWhiz]

It is pretty difficult to tell which Excel version a file was created in
between xl97 and xl02. The differences between them were mostly cosmetic
There were enhancements in forms controls and functions, but the platform
was virtually unchanged. xl07 and later is easy to distingruish because of
the four digit file extension. If you try to save a xl07 fiile in xl03 it
will ask you what you want to save it as, and vice versa in xl07. If using
VBA in different versions, you might get a message that a reference is
missing, but even that cannot be tied directly to a specific version.

 

[CLR]

Ok, thanks JLGWhiz..........
My problem is that I have users with all differing versions of XL and they
even change from time to time, so I have to know which version they are using
so my code will be compatible. Guess I'll just have to do it the "old
fashion way" and keep on asking them.

Vaya con Dios,
Chuck, CABGx3