Excel Version Trap
Hi Amescha,
Possibly, something like:
If CDbl(Application.Version) = 9 Then
'Run your pivot table
Else
'Dont!
End If
---
Regards,
Norman
"amescha" wrote in message
...
Hello All,
I am looking for a listing of MS Excel verions (releases). I have searched
"all of Microsoft.com" to no avail. Specifically I want to keep a VBA
procedure from running if the user has anything less than releases 9.0x or
10.0x. The procedure creates a Pivot Table and Pivot Chart which requires
the aforesaid two versions. I was considering using a Select Case statement
that would result in an appropriate message box and "Exit Sub" unless a
version that handles Pivot Charts is being used. Thanks in Advance!
|