| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application Name differences between Excel 2003 and 2007
A few tests should let you know, right?
SteveM wrote: So Stanley and Dave, Now I can distinguish between Excel 2003 and 2007. Will 2007 always< require [Compatibility Mode] to be appended to the application.name to work with AppActivate? Are there any other modes that might be required instead (or even none at all), and if so, how do I determine them? I want to account for all possible choices with programming to avoid errors. "Dave Peterson" wrote: I bet that there are people running versions of excel that include a letter suffix (xl2002 and prior). I'd use something like: if val(application.version) = 12 then And to save typing select case val(application.version) case is = 12 : msgbox "you are using xl2007" case is = 11 : msgbox "you are using xl2003" ... end select Val() makes it a numeric test, too. stanleydgromjr wrote: SteveM, The following code can be modified to suit your needs. Code: -------------------- Sub ReturnExcelVersion() If Application.Version = "12.0" Then MsgBox "You are using Excel 2007." ElseIf Application.Version = "11.0" Then MsgBox "You are using Excel 2003." ElseIf Application.Version = "10.0" Then MsgBox "You are using Excel 2002." ElseIf Application.Version = "9.0" Then MsgBox "You are using Excel 2000." ElseIf Application.Version = "8.0" Then MsgBox "You are using Excel 97." ElseIf Application.Version = "7.0" Then MsgBox "You are using Excel 95." End If End Sub -------------------- Have a great day, Stan -- stanleydgromjr ------------------------------------------------------------------------ stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126586 -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 differences to 2003 questions | Excel Discussion (Misc queries) | |||
| Differences in Excel macro recording from 2003 to 2007! Help! | Excel Programming | |||
| can you summarize differences between Excel 2000, 2003 & 2007? | Excel Discussion (Misc queries) | |||
| The Differences in the Shell Command in Excel 2003 and 2007 | Excel Programming | |||
| Excel Macros - Any Major Differences Between 2003 and 2007 | Excel Worksheet Functions | |||
Hybrid Mode
