View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Can I detect if user has Excel 2007 and display different pages?

You can test it with

If Val(Application.Version) < 12 Then
'97-2003
Else
'2007
End If

I use it for example on this page
http://www.rondebruin.nl/mail/folder1/mail2.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ...
I spent years developing a software applicaitonthat has extra menu
items at the top, and it works, finally, really well...on Excel 2003.
Along comes 2007, and the add-ins now are hidden from the soccer moms
that use the program in an obscure 'add-on' box. Is there any way that
I can detect that someone using my program has Excel 2007 and display
special help messages or something so that I do not have to rewrite
everything? I have seen ways to change the ribbon back to the 2003
headers, but if the user is familiar with the ribbon concept, that
could even cause more confusion in the future. Thanks in advance
(again).