I have a workbook with formulas that only work in Excel '07 (using the
iferror function). When the workbook is opened, I want to check if the user
opened it with an earlier version of Excel. If they did, I want to tell them
to open it with Excel '07 and then automatically close the workbook.

I think I can handle writing all of the code except the part where I check
what version of excel they are using. The only member of the Application
object that I found which might be useful was Application.Version, but I
don't know if this can be trusted (returns 12.0 for me).

Has anyone else written code to perform the above validation? I would
rather not change all of my functions to include IF stmts instead of
IFERROR...