Mike,

You need application.Version. XL2000 is 9.0, 97 was 8.0 I believe.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mike R" wrote in message
...
Hi,

What code would i put in an Auto_Open macro to detemine the Excel
version. I have written and add-in with XL2000, but half of the users have
xl97 which is generating code errors. I would like CODE to just close the
file unless XL2000 is being used.

Thanks for your help

Mike