| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which version Excel created file?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Which version Excel created file?
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Which version Excel created file?
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. . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Which version Excel created file?
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. . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Which version Excel created file?
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. . . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Which version Excel created file?
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 . |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Which version Excel created file?
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Which version of Excel created the file | Excel Discussion (Misc queries) | |||
| What version Excel file was created in. | Excel Programming | |||
| How to use excel file created in version earlier than 4.0a in 4.0 | Excel Discussion (Misc queries) | |||
| Finding which version of Excel created a file | Excel Programming | |||
| Excel Version in which file was created | Excel Programming | |||
Hybrid Mode
