| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine if the Excel Version is 2007 or previous
I want to determine if the user has Excel Version 2007 or previous
one. If the version is 2007 then i want to run one code else the other one I tried Application.version but it gave 12 as the version number for Excel 2007 I want to do the following If application version is 2007 then ....................... ...............run this code else if previous version ........... ............. run this code end if |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determine if the Excel Version is 2007 or previous
Hi
You need If Val(Appication.version) = 12 Then some code Elae Some other code End if -- Regards Roger Govier Subodh wrote: I want to determine if the user has Excel Version 2007 or previous one. If the version is 2007 then i want to run one code else the other one I tried Application.version but it gave 12 as the version number for Excel 2007 I want to do the following If application version is 2007 then ...................... ..............run this code else if previous version .......... ............ run this code end if |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determine if the Excel Version is 2007 or previous
.... or with 2010 just around the corner
If Val(AppLication.version) = 12 Then Regards, Peter T "Roger Govier" wrote in message ... Hi You need If Val(Appication.version) = 12 Then some code Elae Some other code End if -- Regards Roger Govier Subodh wrote: I want to determine if the user has Excel Version 2007 or previous one. If the version is 2007 then i want to run one code else the other one I tried Application.version but it gave 12 as the version number for Excel 2007 I want to do the following If application version is 2007 then ...................... ..............run this code else if previous version .......... ............ run this code end if |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determine if the Excel Version is 2007 or previous
Quite right, Peter!
Far too blinkered a view on my part. (Might also help if I could spell "else") -- Regards Roger Govier Peter T wrote: ... or with 2010 just around the corner If Val(AppLication.version) = 12 Then Regards, Peter T "Roger Govier" wrote in message ... Hi You need If Val(Appication.version) = 12 Then some code Elae Some other code End if -- Regards Roger Govier Subodh wrote: I want to determine if the user has Excel Version 2007 or previous one. If the version is 2007 then i want to run one code else the other one I tried Application.version but it gave 12 as the version number for Excel 2007 I want to do the following If application version is 2007 then ...................... ..............run this code else if previous version .......... ............ run this code end if |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula link in previous version not updated in Excel 2007 | Excel Worksheet Functions | |||
| Determine version of Excel in VBA | Excel Programming | |||
| How can I determine if a version of Excel 2007 is professional? | Excel Discussion (Misc queries) | |||
| Add-in created for previous of version of Excel | Excel Discussion (Misc queries) | |||
| How do I get hyperlinks, from previous version of excel, to work . | Excel Discussion (Misc queries) | |||
Linear Mode
