Hi,

I am wondering if there is a way to have a macro check to see what version of excel is running and then based on the version perform one of two macros.

I.E.
If the user running the macro has excel 2007, then run the macro which creates the flashy themed pivot tables and reports.
If the user is running the macro in excel 2003, then run the macro which creates a 2003 friendly version without themes, etc.

Most of the workbooks I create are within excel 2007 but saved as .xls files as I send them out to users running excel 2003 as well as 2007.

Anyone know of a way to do this?

Thanks!!

Billy