Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for Excel version before running?
I've gotten calls from some of my users with strange problems, only to find
they are running Excel 97 - my spreadsheet and the VBA in it are all built using Excel 2000. Is there a way to check this when they try to open this? "If Not Excel 2000 Then MsgBox "Don't do this! And don't call me!" " ?? Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for Excel version before running?
Ed,
You can test the Version property of the Application object. For example, If Val(Application.Version) <= 8 Then ' user is in 97 or earlier End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Ed" wrote in message ... I've gotten calls from some of my users with strange problems, only to find they are running Excel 97 - my spreadsheet and the VBA in it are all built using Excel 2000. Is there a way to check this when they try to open this? "If Not Excel 2000 Then MsgBox "Don't do this! And don't call me!" " ?? Ed |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for Excel version before running?
Thank you, Chip. That will be a big help.
Ed "Chip Pearson" wrote in message ... Ed, You can test the Version property of the Application object. For example, If Val(Application.Version) <= 8 Then ' user is in 97 or earlier End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Ed" wrote in message ... I've gotten calls from some of my users with strange problems, only to find they are running Excel 97 - my spreadsheet and the VBA in it are all built using Excel 2000. Is there a way to check this when they try to open this? "If Not Excel 2000 Then MsgBox "Don't do this! And don't call me!" " ?? Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check register running balance to another worksheet | Excel Worksheet Functions | |||
which office version am i running | Excel Discussion (Misc queries) | |||
How do I know what version of excel I am running? | Excel Discussion (Misc queries) | |||
Anyone have troubles running 2003 macros in 2000 version of Excel | Excel Discussion (Misc queries) | |||
VB code needed for running newer excel version macros in older excel versions | Excel Programming |