Hi. I need to detect, in a VBA script, if it is executed by Excel 97. How do
I do that?

Casper

Hi Casper
Application.Version which will return a string value (8.0 for Excel 97)

HTH
Cordially
Pascal

"Casper Hornstrup" a écrit dans le message de
...
Hi. I need to detect, in a VBA script, if it is executed by Excel 97. How
do
I do that?

Casper

Hi Casper

Sub WhichVersion()
MsgBox "Excel Version " & Application.Version
End Sub

Excel 97 is, I believe, Version 8.
--

XL2002
Regards

William



"Casper Hornstrup" wrote in message
...
| Hi. I need to detect, in a VBA script, if it is executed by Excel 97. How
do
| I do that?
|
| Casper
|
|

MsgBox "You're running Excel version " & Application.Version

It returns 10.0 for XP, what I'm running. I'm not sure what 97 will be
I'd guess 8.0, assuming that Office 2000 was version 9.0.

-Gitcyphe

--
Message posted from http://www.ExcelForum.com

Casper,

Be sure to be able to sense "8.0a" for Excel97 with SR-1. I think 8.0b is
SR-2, which I installed on my old Excel97 machine, but Help - About says
SR-1, and Application.Version returns 8.0a. Oh well. Anyway, something
like:

If Left(Application.Version, 3) = "8.0" then...
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Casper Hornstrup" wrote in message
...
Hi. I need to detect, in a VBA script, if it is executed by Excel 97. How
do
I do that?

Casper