View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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!