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

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

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