| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 97-2007
I need to know if the application running my macro is Excel 97 or Excel
2007. Is there a way to find out? Thanks Fred |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97-2007
Application.version returns a number. the ones with questions I 'm not sure.
Excel 95 = 7.0 Excel 98 = 8.0 Excel 2002 = 9.0 ???? Excel 2003 = 10.0 Excel 2005 = 11.0 ???? Excel 2007 = 12.0 ???? "Fred" wrote: I need to know if the application running my macro is Excel 97 or Excel 2007. Is there a way to find out? Thanks Fred |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97-2007
There was an Excel 2005?
"Joel" wrote: Application.version returns a number. the ones with questions I 'm not sure. Excel 95 = 7.0 Excel 98 = 8.0 Excel 2002 = 9.0 ???? Excel 2003 = 10.0 Excel 2005 = 11.0 ???? Excel 2007 = 12.0 ???? "Fred" wrote: I need to know if the application running my macro is Excel 97 or Excel 2007. Is there a way to find out? Thanks Fred |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97-2007
97 = 8.0
2000 = 9.0 2002 = 10.0 2003 = 11.0 2007 = 12.0 98 and 2005 must be for the Mac. Don't know about them. Gord Dibben MS Excel MVP On Mon, 25 Aug 2008 16:57:03 -0700, Joel wrote: Application.version returns a number. the ones with questions I 'm not sure. Excel 95 = 7.0 Excel 98 = 8.0 Excel 2002 = 9.0 ???? Excel 2003 = 10.0 Excel 2005 = 11.0 ???? Excel 2007 = 12.0 ???? "Fred" wrote: I need to know if the application running my macro is Excel 97 or Excel 2007. Is there a way to find out? Thanks Fred |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97-2007
Application.Version will give you the version number of the Excel that is
running your code. Rick "Fred" <leavemealone@home wrote in message ... I need to know if the application running my macro is Excel 97 or Excel 2007. Is there a way to find out? Thanks Fred |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97-2007
Hi Fred
If you test it with Application.Version Always use Val like this If Val(Application.Version) < 12 Then For example Application.Version will give thison my US system with Excel 2007 12.0 and this on my Dutch system 12,0 Use Val(Application.Version) to avoid problem 12=2007 11=2003 10=2002 9=2000 8=97 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Fred" <leavemealone@home wrote in message ... I need to know if the application running my macro is Excel 97 or Excel 2007. Is there a way to find out? Thanks Fred |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 files not showing on screen when opened in Excel 2007 | Setting up and Configuration of Excel | |||
| Conflict in excel 2007 with Outlook 2007 attachment excel | Excel Discussion (Misc queries) | |||
| Labels: Unable to import all records Excel 2007 to Word 2007 Mailm | Excel Discussion (Misc queries) | |||
| Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros andcons please | Excel Programming | |||
| Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Hybrid Mode
