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



"JLGWhiz" wrote:

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" wrote in message
...
Ok, thanks anyway Hector.......that C++ stuff is out of my league.

Vaya con Dios,
Chuck, CABGx3



"Héctor Miguel" wrote:

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


.



.