Thread: Excel 97-2007
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Excel 97-2007

Application.version returns a number. the ones with questions I 'm not sure.

Excel 95 = 7.0
Excel 98 = 8.0
Excel 2002 = 9.0 ????
Excel 2003 = 10.0
Excel 2005 = 11.0 ????
Excel 2007 = 12.0 ????

"Fred" wrote:

I need to know if the application running my macro is Excel 97 or Excel
2007.
Is there a way to find out?

Thanks
Fred